S
sukhin
I have an Excel workbook (A) in excel XP that contains VBA code to open
workbook B.
Application.AutomationSecurity = msoAutomationSecurityForceDisable
Application.EnableEvents = False
Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value)
Application.AutomationSecurity = msoAutomationSecurityLow
Now B has some Auto_open macros in it and what happens after the the
above lines execute is that control seems to transfer to the VBA code
in B alhtough nothing really runs
My code in A is then reset and goes back to the start of the sub
without executing any statements after
Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value)
Any help would be appreciated.
Thanks,
Sukhin
workbook B.
Application.AutomationSecurity = msoAutomationSecurityForceDisable
Application.EnableEvents = False
Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value)
Application.AutomationSecurity = msoAutomationSecurityLow
Now B has some Auto_open macros in it and what happens after the the
above lines execute is that control seems to transfer to the VBA code
in B alhtough nothing really runs
My code in A is then reset and goes back to the start of the sub
without executing any statements after
Set LHSwb = Workbooks.Open(LHS_PATH & "/" & LHS_files.Value)
Any help would be appreciated.
Thanks,
Sukhin