Macro ignors module code
 

Try using the Workbook_Open event instead.


--
Regards,


Bill Lunney
www.billlunney.com

"Phil Hageman" wrote in message
...
I have the following macro code in the Personal.xls
workbook to open a workbook:

Sub OpenBSC()
Workbooks.Open ("W:\Housing\Housing BSC for 2004.xls")
End Sub

However, the sub ignores an AutoOpen() sub in the target
workbook's Module1. How do I make the macro run the
Module1 AutoOpen() in the target workbook?

Thanks, Phil

Macro ignors module code
 

Bill, thanks for the help - got it working.
-----Original Message-----
Try using the Workbook_Open event instead.


--
Regards,


Bill Lunney
www.billlunney.com

"Phil Hageman" wrote in message
...
I have the following macro code in the Personal.xls
workbook to open a workbook:

Sub OpenBSC()
Workbooks.Open ("W:\Housing\Housing BSC for 2004.xls")
End Sub

However, the sub ignores an AutoOpen() sub in the target
workbook's Module1. How do I make the macro run the
Module1 AutoOpen() in the target workbook?

Thanks, Phil


.