Excel sheet with form - Path/File access error

J

Jon

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform problem with "Run Time Error 75" 15
Path/File access error (Error 75) 6
Excel - Access Integration 2
Problem with file path to sharepoint 0
EX2007 - Error 1004: method 'VBProject' of object '_Workbook' failed 15
Loading an Excel User Form 3
path error when pointing/going to userform1 1
"Coult not find specified object" and "Path-File access error" messages 2

Top