Disable Workbooks_Open() Macro when opening from VBA

[DavidUp]

I am trying to open a Workbook "Permanent File Information.xls" from a macro
in another workbook without invoking the workbooks_open macro in "Permanent
File Information.xls"

This is the equivalent of holding down the <shift> key whilst opening the
workbook.

I have tried recording two macros to see what the difference is but although
they give different macros they both allow the workbooks_open macro to run
when the two macros are run.

Sub OpenWorkBook()
Workbooks.Open Filename:= _
"F:\Files\Permanent File Information.xls"
End Sub
Sub ShiftOpenWorkbook()
Workbooks.Open Filename:= _
"F:\PA Files\Permanent File Information.xls", Editable:=True
End Sub

Has anyone got any ideas how to stop the workbooks_open macro running from
VBA?

Thank you

 

[Bob Phillips]

Sub OpenWorkBook()
Application.EnableEvents = False
Workbooks.Open Filename:= _
"F:\Files\Permanent File Information.xls"
Application.EnableEvents = True
End Sub


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)