Bypass Workbook Open Event

[aziz rasul]

When pressing a command button on a form to open an Excel file, is it possible to prevent the Workbook event from firing up?

 

[tgroneck]

Try:

Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = True
objExcel.EnableEvents = False
objExcel.Workbooks.Open "C:\test.xlsm"
objExcel.EnableEvents = True

 

[aziz rasul]

I didn't realise it would be as simple as that. Many thanks.