Macro to call a file that has a auto open macro in the file itself
 

Please help,

I am writing a MS Excel macro to open an Excel file that has an auto
execute macro also upon opening. Whenever I called up the file, it
will also execute its own macro. What I wanted to do is to disable the
auto open macro in the called file. I just wanted it to plainly open
the file I called.

Thanks in advance.

Macro to call a file that has a auto open macro in the file itself
 

Hi AR,

Try something like:


Sub Tester()

Application.EnableEvents = False
Workbooks.Open "YourWorkBook"
Application.EnableEvents = True


End Sub


---
Regards,
Norman



wrote in message
ups.com...
Please help,

I am writing a MS Excel macro to open an Excel file that has an auto
execute macro also upon opening. Whenever I called up the file, it
will also execute its own macro. What I wanted to do is to disable the
auto open macro in the called file. I just wanted it to plainly open
the file I called.

Thanks in advance.