Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error 75
Hello.
I have a worksheet that the Workbook_Open event to load a userform. The code is: Private Sub Workbook_Open() Load UserForm1 UserForm1.Show ActiveWorkbook.Close SaveChanges:=False End Sub When the user exits UserForm1, control passes back to workbook_open macro, and the workbook is closed. When I open the worksheet for the first time, everything works fine. However, when I exit via the above code, and then reopen the worksheet, I get the following VB errors: "Path/File Access Error", and "Run-Time Error 75, Cannot find the specified object" When I hit the DEBUG button, the "Load Userform1" is highlighted (see code, above). Apparently, it cannot find UserForm1. Also, when this error occurs, the Project Explorer window appears blank -- nothing is in it. If I hit END in the Error box, Excel crashes. This worksheet and macro was originally designed in Excel 97, and it ran fine. Now, I'm using Excel 2002 with Windows XP. I recently installed an update for Excel, but the problem still exists. Does anyone know what is going on? Thanks! -Jon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Same problem
Jon I am having the exact same problem I have multiple users access a
spreadsheet and I they don't save the changes when finished. When they open the sheet for the first time it works fine, however if they don't close excel out completely and try to reopen the program they get runtime errors and catastrophic failures. If i try to debug them half the time excel will crash. I'm using multiple userforms in this spreadsheet as well. I'm real interested in finding a solution to this as I'm sure you are! Eric "Jon" wrote: Hello. I have a worksheet that the Workbook_Open event to load a userform. The code is: Private Sub Workbook_Open() Load UserForm1 UserForm1.Show ActiveWorkbook.Close SaveChanges:=False End Sub When the user exits UserForm1, control passes back to workbook_open macro, and the workbook is closed. When I open the worksheet for the first time, everything works fine. However, when I exit via the above code, and then reopen the worksheet, I get the following VB errors: "Path/File Access Error", and "Run-Time Error 75, Cannot find the specified object" When I hit the DEBUG button, the "Load Userform1" is highlighted (see code, above). Apparently, it cannot find UserForm1. Also, when this error occurs, the Project Explorer window appears blank -- nothing is in it. If I hit END in the Error box, Excel crashes. This worksheet and macro was originally designed in Excel 97, and it ran fine. Now, I'm using Excel 2002 with Windows XP. I recently installed an update for Excel, but the problem still exists. Does anyone know what is going on? Thanks! -Jon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Run time error 1004, General ODBC error | New Users to Excel | |||
Befuddled with For Next Loop ------ Run - Time Error '13' Type Mismatch Error | Excel Programming | |||
Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Run-time error '11' & Run-time error '1004' | Excel Programming |