Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open vs Open and call macro --priority question
Hi:
I have a spreadsheet called "collector.xls" that contains a macro "auto_open", which is intended to execute when ever the sheet is opened. I am calling this sheet from another sheet (opening the sheet in question and then calling a macro in the sheet I just opened"), as in Workbooks.Open Filename:="C:\IPT\timesheets\Collector.xls" Application.Run "Collector.xls!Collectorcheckandmove" My question is whether the auto-open macro in the collector will execute before the macro I am calling from the external spreadsheet. Thanks for he response John Baker |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open vs Open and call macro --priority question
Hi John
Auto_open won't run at all when you open from code. Unless you request it to run like this: ActiveWorkbook.RunAutoMacros (xlAutoOpen) These things are pretty easy to test for yourself with something like Sub Auto_open() MsgBox "HI from Auto_open" End Sub -- HTH. Best wishes Harald Followup to newsgroup only please. "John Baker" wrote in message ... Hi: I have a spreadsheet called "collector.xls" that contains a macro "auto_open", which is intended to execute when ever the sheet is opened. I am calling this sheet from another sheet (opening the sheet in question and then calling a macro in the sheet I just opened"), as in Workbooks.Open Filename:="C:\IPT\timesheets\Collector.xls" Application.Run "Collector.xls!Collectorcheckandmove" My question is whether the auto-open macro in the collector will execute before the macro I am calling from the external spreadsheet. Thanks for he response John Baker |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open vs Open and call macro --priority question
In article ,
John Baker wrote: Hi: I have a spreadsheet called "collector.xls" that contains a macro "auto_open", which is intended to execute when ever the sheet is opened. I am calling this sheet from another sheet (opening the sheet in question and then calling a macro in the sheet I just opened"), as in Workbooks.Open Filename:="C:\IPT\timesheets\Collector.xls" Application.Run "Collector.xls!Collectorcheckandmove" My question is whether the auto-open macro in the collector will execute before the macro I am calling from the external spreadsheet. Actually, the auto-open macro won't run at all. Auto-macros will run if the file is opened directly (via the file menu or from the Finder), but will not run when opened from code. To get automacros to run, you need to use Workbooks.Open Filename:="C:\IPT\timesheets\Collector.xls" ActiveWorkbook.Autorun xlAutoOpen Application.Run "Collector.xls!Collectorcheckandmove" Alternatively, you can run macros on opening (whether from code or direct) by calling it from, or including it in, the opened workbook's Workbook_Open() event. Put this in the ThisWorkbook code module: Private Sub Workbook_Open() MyOpenMacro 'or include macro here End Sub In general, if opening directly, Auto_Open macros run after all event macros associated with opening a file, but before your Application.Run call. To see the order of firing: http://cpearson.com/excel/events.htm |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto_Open vs Open and call macro --priority question
Just and added comment.
ActiveWorkbook.RunAutoMacros (xlAutoOpen) really shouldn't have parens around the argument since you are not returning a value. It doesn't cause a problem here, but could if the argument were an object. ActiveWorkbook.RunAutoMacros xlAutoOpen -- Regards, Tom Ogilvy Harald Staff wrote in message ... Hi John Auto_open won't run at all when you open from code. Unless you request it to run like this: ActiveWorkbook.RunAutoMacros (xlAutoOpen) These things are pretty easy to test for yourself with something like Sub Auto_open() MsgBox "HI from Auto_open" End Sub -- HTH. Best wishes Harald Followup to newsgroup only please. "John Baker" wrote in message ... Hi: I have a spreadsheet called "collector.xls" that contains a macro "auto_open", which is intended to execute when ever the sheet is opened. I am calling this sheet from another sheet (opening the sheet in question and then calling a macro in the sheet I just opened"), as in Workbooks.Open Filename:="C:\IPT\timesheets\Collector.xls" Application.Run "Collector.xls!Collectorcheckandmove" My question is whether the auto-open macro in the collector will execute before the macro I am calling from the external spreadsheet. Thanks for he response John Baker |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Priority (with macro??) | Excel Worksheet Functions | |||
Auto_Open Macro | Excel Discussion (Misc queries) | |||
Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
Auto_Open vs. macro | Excel Programming | |||
Workbook Open Vs Auto_Open | Excel Programming |