Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an ellaborate VBA project that does of most of any needed
openening and closing of workbooks. I am trying to make it so everything remains under control when a user opens and closes workbooks directly from excel. Anyway, the details are to involved to get into now, but here is a very strange symptom that happens if a workbook is closed directly from excel and then opened from code within VBA: Any statements after workbooks.open <nameofworkbook_just_closed never are executed. What is particularly difficult in trying to debug this is that when you step through the code using F8 key, the code does *not* quit on the workbook.open, but continues to completion as intended. Anybody ever seen this symptom and know what possible causes there are? No need to suggest using On Error Goto 0. That has already been done . . . Thanks a-million for any suggestions. Nick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel quits unexpectedly | Excel Worksheet Functions | |||
Open form to specific record quits working | New Users to Excel | |||
When I open Excel, workbooks open automatically. How can I stop t | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |