Rx_
Nothing In Moderation
- Local time
- Today, 12:43
- Joined
- Oct 22, 2009
- Messages
- 2,803
Attempting to automate the textbox or label from Access 2007 using Excel 2007 automation.
When using the Excel Record Macro
It does not record adding a text box.
For OLEObjects, it records the initial name and location, but nothing else.
Some blogs mentioned that Excel 2003 works, but not Excel 2007.
Any ideas?
After searching for a while, this seems to be the answer
http://support.microsoft.com/kb/937620
MS claims that this is by design - It is so sad....
When using the Excel Record Macro
It does not record adding a text box.
For OLEObjects, it records the initial name and location, but nothing else.
Some blogs mentioned that Excel 2003 works, but not Excel 2007.
Any ideas?
After searching for a while, this seems to be the answer
http://support.microsoft.com/kb/937620
MS claims that this is by design - It is so sad....
Last edited:
