Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I figured it out. I didn't realize that I only had MS Office referenced,
instead of Office and Word. The macro is running now. I have one more question. I need to run this macro for several documents, do I need to make a complete new macro for each document or is there a way that I can add the docs to this macro have it work for each doc.? "Michelle Hanan" wrote in message ... I understand what you're saying Tony, however when I run the macro in excel it highlights the myDoc as Word.Document line of code and gives me a compile error: User-defined type not defined. I don't understand why or how to fix it. "tony h" wrote in message ... Trying to get the referencing right is not easy in these situations if you don't have much experience. A first step though : change ActiveDocument to myDoc. Basically at the beginning you open the document and "call it" myDoc. Now no matter what else happens if you use myDoc it is the document you opened. Whereas ActiveDocument is just the document that is active at the time - which maynot be the one you opened. This point is true for anything that is labelled Active... or current... etc Do you know how to use the debug tools? look up these - especially F8. hope this helps -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=560754 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro buttons opening saved macro | Excel Discussion (Misc queries) | |||
run macro on opening | Excel Discussion (Misc queries) | |||
Macro upon opening | Excel Worksheet Functions | |||
Run Macro Upon Opening | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |