Opening Files in Macros

walding · May 17th, 2002, 06:28 AM

Hi,

I am confused as to why this doesn't work.

I have the following lines below in the middle of my VBA macro:

Workbooks.Open Filename:="excelfile.xls", ReadOnly:=True
MsgBox "Here"

It opens the file and continues to run the script, if run from within VBA Editor.
If run from within excel (e.g. pressing a button), then it exits the script after opening (doesn't even display the message box).

Help!!

Andrew

walding · May 17th, 2002, 08:06 AM

Alternatively, can I access cells in another workbook without having the 'workbooks.open' method?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 17th, 2002, 06:28 AM	#1
walding Join Date: May 2002 Posts: 34	Hi, I am confused as to why this doesn't work. I have the following lines below in the middle of my VBA macro: Workbooks.Open Filename:="excelfile.xls", ReadOnly:=True MsgBox "Here" It opens the file and continues to run the script, if run from within VBA Editor. If run from within excel (e.g. pressing a button), then it exits the script after opening (doesn't even display the message box). Help!! Andrew

May 17th, 2002, 08:06 AM	#2
walding Join Date: May 2002 Posts: 34	Alternatively, can I access cells in another workbook without having the 'workbooks.open' method?