can’t find project or library

[BrodyNoochie]

I created a new macro the other day and it was working fine. Today when I attempted to open it, i received the error "Can't find project or library" immediately when opening the sheet. I found the support on the microsoft website indicating to:


Open your database.
Press ALT+F11 to switch to the Visual Basic Editor.
Open a module in Design view.
On the Tools menu, click References.
Click to clear the check box for the type library or object library marked as MISSING: <referencename>


unfortunately, when i try to open it in Visual Basic Editor, it freezes up and i am able to do anything.
I have tested getting into other macros and they are working fine. I have also attempting starting a new one and had no issues there either. It seems isolated to this specific one.


Anyone have any ideas? at this point, just getting my code when be sufficient.


Thanks

 

[Dryver14]

You could try saveas .xlsx and see if you get any interference that way, if it works you could copy the macro to a different file, would be good to find out what caused it though
as this could repeat

 

[BrodyNoochie]

this attempt led to new errors.
"Excel encountered errors during save. However Excel was able to minimally save you file to" and then gives a location on my computer. I attempted to go to that location but it does not exist.

any other ideas before i restart?

 

[daverunt]

You could try moving the vba project to a new file and opening it but it is likely the project itself may have an issue. Worth 5 minutes though.

Use a copy of the dodgy file if possible.

- Create a new .xlsx file - junk.xlsx.
Save the file as junk.xlsm
ALT+F11 and add a blank module in the VBA project. - !important.
Rename the file - junk.xlsm to junk.zip
Open the file in win zip
open the xl folder
You should see vbaproject.bin
You are going to replace this file with the vbaproject.bin from your dodgy file

On your dodgy file:
rename the file to .zip
Open the file in Win Zip or other
Open the xl folder

Drag that from the zip file into the folder you are working in and drop it into the xl folder in junk.zip

close the zip
rename junk.zip to junk.xlsm

Attempt to open the file.

 

[BrodyNoochie]

I gave it a try and it didnt work. So, i ended up starting from scratch.

Thanks for the ideas though! it was worth a shot.