Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening Excel spreadsheet | Excel Discussion (Misc queries) | |||
Opening more than 1 Excel Spreadsheet | Excel Discussion (Misc queries) | |||
Opening a spreadsheet in excel | Excel Discussion (Misc queries) | |||
Opening Excel spreadsheet in MAC | Excel Discussion (Misc queries) | |||
Opening an excel spreadsheet | Excel Worksheet Functions |