In VBA, Open a file with macros disabled

  • Thread starter Thread starter Otto Moehrbach
  • Start date Start date
O

Otto Moehrbach

Excel 2002, WinXP
My macro security is set to Medium.
I have a file that I need to open (in VBA) in order to extract some data
from it, then close it. That file has Open and Close event code that I
don't want to run during this task.
How do I code to open that file with macros disabled?
Or how can I code to open that file such that the Open/Close code will not
execute?
Thanks for your help. Otto
 
Application.EnableEvents = False
set bk = Workbooks.Open( Filename:="C:\MyFolder\MyFile.xls")
' process workbook
bk.Close
Application.EnableEvents = True
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening a list of Excel files and run a macro in each 17
How to browse folder and open xls file automatically in vba? 6
Macro to generate powerpoint slides 43
Disable Macro Alert 2
Macros problem closing another file 0
open file with macros disable 1
VBA Macros and Windows 7 1
Macro that will insert a simple text string in top cell of text file 1

Back
Top