VBA to open a workbook without triggering open event?

[Richard U]

With office 365 on the horizon, I need to catalogue all of our spreadsheets, and identify links.

I am doing this by creating a workbook object, setting the object to"

Set wb = Workbooks.Open(path & file)
var_Links = wb.LinkSources(xlExcelLinks) 'set variant = excel links

This works great until I hit a few tools that have Workbook_Open events where the macros start executing.

Is there any way to suppress the events when opening the new workbook?

 

[Fluff]

Try

Application.EnableEvents = False
Set wb = Workbooks.Open(path & file)
Application.EnableEvents = True
var_Links = wb.LinkSources(xlExcelLinks) 'set variant = excel links