VBA Stop other macros running when opening linked Excel file
Posted on 2006-06-12
I am having a problem with macros running in an excel file when I open it in the background to update linked data in my word tables. I am aware that you can turn macros off in Excel by using the Application.EnableEvents = False command but do not know how to fit this in with my current Open Excel File command. Any Ideas?
Below is the line that I am currently using in the opening of the excel file
Set mobjXLWorkBook = mobjXLApp.Workbooks.Open(FileName:=strPath, UpdateLinks:=False, ReadOnly:=blnReadOnly)