View Single Post
  #2 (permalink)  
Old 11-11-09, 09:11
paulzak paulzak is offline
Registered User
 
Join Date: May 2004
Posts: 54
SOLVED:

I found the solution the next day myself. AutomationSecurity is required.

Here is the code that seems to work for me.
================================================== ==

Application.AutomationSecurity = msoAutomationSecurityByUI

Workbooks.Open Filename:="C:\Users\xl\Documents\aaa.xlsm"
Reply With Quote