Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My spreadsheet (main.xls) has a number of macros. One of them (macro1)
tries to open another spreadsheet (file.xls). However, when file.xls opens, the macro stops, rather than continuing with the rest of its code. I have similar code in macro2, but it seems to work as expected. An excerpt from macro1 code: .. ChDir (ActiveWorkbook.Path) ' main.xls and file.xls are in the same folder on C: .. Workbooks.Open (file.xls) ' file.xls does not include the path x = 1 .. Running macro1, file.xls opens and macro1 stops. If the breakpoint is set on the x = 1 line, execution never gets there. If the Breakpoint is set on the Open line, execution halts there, but pressing F8 (or F5) will cause macro1 to continue normally. Normally includes executing similar code farther on in macro1. Any suggestions? I've tried everything I can think of. FYI, I'm fairly new to Excel, and particularly to VBA. I am experienced in several forms of Basic, and a couple other high level languages. Perhaps there's a workaround. All I really want to do is open file.xls, copy a little bit of stuff into it, and then close it. I plan on doing this to half a dozen files.xls. Respectfully submitted, Bob Myers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a macro be run on opening the file? | Excel Discussion (Misc queries) | |||
Can a macro be run on opening the file? | Excel Discussion (Misc queries) | |||
Formula stops working after re-opening worksheet | Excel Worksheet Functions | |||
Opening a file with a Macro | Excel Discussion (Misc queries) | |||
After deleting a macro, I still get the pop-up when opening file | Excel Worksheet Functions |