Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto open macros in Excel
I'm trying to create an auto_open macro which saves the workbook being
opened into a certain directory if it hasn't already been saved. I placed the code in the Workbook_open event in book.xlt and this works on Workbooks created after I added the code but doesn't run on any workbooks created before. I've tried adding the auto_open code in an addin but this only seems to run when Excel starts up (and the addin opened I guess). I'm new to Excel programming (experienced in Word programming but that's it). I've searched the groups and found a lot on auto_open macros but can't get any to work ... Any help greatly appreciated!! Cheers, Tammy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto open macros in Excel
Once a workbook is created from a template, it has no more connection to
that template, so any changes you make to the xlt file will not be reflected in any previously created workbook. There is no accessible attribute in a workbook that will tell you it was created from a specific template file. -- Regards, Tom Ogilvy "Tammy" wrote in message om... I'm trying to create an auto_open macro which saves the workbook being opened into a certain directory if it hasn't already been saved. I placed the code in the Workbook_open event in book.xlt and this works on Workbooks created after I added the code but doesn't run on any workbooks created before. I've tried adding the auto_open code in an addin but this only seems to run when Excel starts up (and the addin opened I guess). I'm new to Excel programming (experienced in Word programming but that's it). I've searched the groups and found a lot on auto_open macros but can't get any to work ... Any help greatly appreciated!! Cheers, Tammy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros - Open an access file from de Excel? | Excel Discussion (Misc queries) | |||
Can't Open Excel Files with Macros | Excel Discussion (Misc queries) | |||
How do I set Excel to auto open a document into a new Window even. | Excel Worksheet Functions | |||
Macro Size Limit / open macros with macros? | Excel Programming | |||
invoke macro from outside excel - auto macros | Excel Programming |