What's this error, Please help.

[RBrown]

I have been working on a project for several weeks that has two forms and a lot of code and all of a sudden I get the following error:

"Error Accessing File. Network connection may have been lost"

I can see my modules in the project explorer window but I can't open them.
Can anyone tell me if there is a fix for this error.

 

[lozzablake]

Do you get this error when you try to open the file or when you run the macro?

 

[RBrown]

I get the error when the workbook is opened, I assume this is because it's trying to load a form but can't access the code and I also get it if I try to view any of the codes thru the project explorer or if I try to manually run any of the macros.

 

[lozzablake]

The code is stored with the workbook unless there is a specific call to code in another workbook.

As this happens when you open the workbook there must be an event macro for the workbook. On the project explorer, if you click on the ThisWorkbook icon do you see any code?

 

[RBrown]

No... I get the same error when I try that just as I do when I try to view code for any worksheet, userform or module.

 

[lozzablake]

Is there anything in the workbook at all or is it a blank workbook that gets opened?

 

[RBrown]

There are three worksheets, one is a time card template(hidden), one is used to store listbox values (hidden) and the other is a blank that is displayed when the workbook is first opened.

I would gladly e-mail it to you if you like.

 

[lozzablake]

Sorry what I meant was are these worksheets blank or are they as you expect?

On the whole with this type of error I would expect you to be unable to open the file at all. Or there to be code trying to access another file. The fact that the modules cannot be accessed seems to indicate that perhaps there is some corruption somewhere.

Have you tried doing a File Save As and then tying to re-open the new file? Also you could try simply copying the file and then trying to open the duplicate version

 

[RBrown]

Yes the worksheets are as they should be and I have tried a Save As and tried a copied version as well as e-mailing it to another user to try. Nothing seems to work.
I looked on Microsofts web site for this error and found it but only as a Power Point Visual Basics error, no mention of it in Excel.

 

[lozzablake]

Well I am sorry I am stumped. It may just be a file corruption. Do you have a back-up?