I have created an Auto_Open sub which does properly execute if the workbook
is opened via Windows. But if the same workbook is opened via a VBA
statement from within another workbook, the Auto_Open does not execute even
though the workbook in fact is opened.

Any suggestions?
--
Lon Sarnoff

Hi Lon,

See VBA help on the RunAutoMacros method.

The following worked for me:

Sub aMacro()
Workbooks.Open "MyTest.xls"
ActiveWorkbook.RunAutoMacros xlAutoOpen
End Sub

---
Regards,
Norman



"Lon Sarnoff" wrote in message
...
I have created an Auto_Open sub which does properly execute if the workbook
is opened via Windows. But if the same workbook is opened via a VBA
statement from within another workbook, the Auto_Open does not execute
even
though the workbook in fact is opened.

Any suggestions?
--
Lon Sarnoff

The activeworkbook line solved the problem. Thank you.
--
Lon Sarnoff


"Norman Jones" wrote:

Hi Lon,

See VBA help on the RunAutoMacros method.

The following worked for me:

Sub aMacro()
Workbooks.Open "MyTest.xls"
ActiveWorkbook.RunAutoMacros xlAutoOpen
End Sub

---
Regards,
Norman



"Lon Sarnoff" wrote in message
...
I have created an Auto_Open sub which does properly execute if the workbook
is opened via Windows. But if the same workbook is opened via a VBA
statement from within another workbook, the Auto_Open does not execute
even
though the workbook in fact is opened.

Any suggestions?
--
Lon Sarnoff

Take a look at .runautomacros in VBA's help. (You have to run that other
auto_open sub yourself.)

Lon Sarnoff wrote:

I have created an Auto_Open sub which does properly execute if the workbook
is opened via Windows. But if the same workbook is opened via a VBA
statement from within another workbook, the Auto_Open does not execute even
though the workbook in fact is opened.

Any suggestions?
--
Lon Sarnoff

--

Dave Peterson