How: open a workbook with auto macro disabled using code?

I am trying to open a number of workbooks from VBA in excel and I need to
open them with macros disabled or auto macro disabled. This is because the
worksheets I need to open have an auto macro which loads data from a server
and I do not want it to run.
Thanks.

Application.EnableEvents = False
workbooks.Open "C:\MyFolder\Myfile.xls"
Application.EnableEvents = True

disables the startup macros.

--
Regards,
Tom Ogilvy

"mike_cutting-edge" <[email protected]> wrote in
message news:[email protected]...
> I am trying to open a number of workbooks from VBA in excel and I need to
> open them with macros disabled or auto macro disabled. This is because the
> worksheets I need to open have an auto macro which loads data from a
server
> and I do not want it to run.
> Thanks.