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