Opening an Excel spreadsheet from within an Excel spreadsheet

D

dhputnam

I am writing a macro in Excel 2003 that opens another Excel spreadsheet using
the following VB statement:

Set RELReport = Workbooks.Open(s_externalLink, 0, ReadOnly:=True)

RELReport is a workbook object, and s_externalLink contains the path and
file name of the spreadsheet to open. The spreadsheet opens OK, but then the
macro hangs and won't go to the next Visual Basic statement. If I put a
breakpoint on or just prior to this statement and step through the code in
the debugger, it works fine, but without using the debugger, it hangs every
time.

Can anyone tell me how to fix this problem? Thanks.
 
D

Dave Peterson

Just a guess...

How do you invoke the macro? Do you use a shortcut key (like: ctrl-shift-A).

If you do, try dropping the shift from the key combination.
 
D

dhputnam

Dave,

Thank you very much for your guess! I removed the shortcut key entirely and
the problem went away. I now invoke the macro from a command button.

Don
 

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 an Excel Spreadsheet from Access with VBA 9
Running a macro from the spreadsheet 4
Extracting data from an excel spreadsheet 3
Tracing where spreadsheet is opened from 1
VB Error in spreadsheet with no VBA code 2
Sub Workbook_Open not called when opening spreadsheet 6
Print spreadsheet replacing recipient name 4
Emailing an Excel Spreadsheet 3

Top