VB Code is gone! Job on the line

[Stevep4]

I created a xlsm file that created like 10 reports automatically. I go to open the file and it says "Can't find project or library." All the code is gone. I can't save the file as a new file. Basically I can't do anything. I tried to go into the vb editor but it won't let me. I'm numb. numb. anyone have any ideas?

 

[Nine Zero]

is the file a "shared" file?

 

[mrshl9898]

Does the Object Library show anything missing?

 

[Fazza]

backup (copy)?

 

[Eric W]

If you don't have a backup, Windows might have a copy. From Windows Explorer, right click on the file name > Properties > Previous Versions.

 

[Derek Brown]

Have you tried starting Excel and then using File/Open to look to see if the option "Recover Unsaved Workbooks" provides a solution?

If this is on a work server, the company should be taking backups nightly etc.

 

[RoryA]

You shouldn’t get a “can’t find project or library” error unless excel is trying to compile or run some code, so there must be code there.

 

[Stevep4]

There's no backup. thanks

 

[Stevep4]

All I see is a white screen. All the code is gone. can't do anything. when I hit alt f11 it opens vb but it's just blank. when I go to tools, references it doesn't do anything. It's all just gone.

 

[RoryA]

If you disable macros in the Trust Center and then open the workbook, is the code there? It sounds like your code is running and basically freezing Excel to me, possibly with screen updating still turned off.