Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet with form - Path/File access error
Hi. I use Excel 2003. I created a control toolbox form accessing data in the
workbook. Added code to load & show the form when workbook is opened. The first time it is opened, no problem. The second time it is opened (without reopening Excel) I get first a "Path/File access error", and the debugger highlights the line "Load UserForm1". The odd thing is there are no projects in the Project Window and if you click in the Properties drop down it shows "Workbook" multiple times. Since it can't see the project it can't load the form. When I stop the debugger it wants to send error report. I've tried creating from scratch but receive the same error. Seems like corruption but not sure how to proceed. Thanks for any help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel sheet with form - Path/File access error
Hi
As always show us your code, so we know where to start. Regards, Per "Jon" wrote: Hi. I use Excel 2003. I created a control toolbox form accessing data in the workbook. Added code to load & show the form when workbook is opened. The first time it is opened, no problem. The second time it is opened (without reopening Excel) I get first a "Path/File access error", and the debugger highlights the line "Load UserForm1". The odd thing is there are no projects in the Project Window and if you click in the Properties drop down it shows "Workbook" multiple times. Since it can't see the project it can't load the form. When I stop the debugger it wants to send error report. I've tried creating from scratch but receive the same error. Seems like corruption but not sure how to proceed. Thanks for any help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Path/File access error | Excel Discussion (Misc queries) | |||
Path/File Access Error | Excel Programming | |||
Path/file access error | Excel Programming | |||
Path/File access error | Excel Programming | |||
Path/File Access Error | Excel Programming |