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.

Hi AR,

Try something like:


Sub Tester()

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


End Sub


---
Regards,
Norman



<arvinsison@gmail.com> wrote in message
news:1123219937.840383.38140@z14g2000cwz.googlegroups.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.
>