View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dhputnam dhputnam is offline
external usenet poster
 
Posts: 7
Default Opening an Excel spreadsheet from within an Excel spreadsheet

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.