"Can't find project or library error" while opening an Excel file

[sarahjane874]

Hello guys,

I programmed a VBA Code, which worked fine until today.
With the Code, I open, edit, save and close an Excel file. I am using Excel 2013.
(I used the fso object, so I checked the box "Microsoft Scripting Runtime". The Code worked fine with that.)

After running that Code I tried to reopen this file and the mentioned above error occured.
At first, the file opens, then a window occurs, which is normal (if I want to update some links) but it doesn't matter if I chose "update" or "don't update". After that window disappears nothing is working anymore.

I was looking on the internet to fix that error on my own - but unfortunately there are no "Missing" boxes in the VBA Reference Window. Now I don't know what to do.

Could you please help me?

Do you need some other information?

Thanks a lot in advance.

Best regards,

Sarah-Jane

 

[Kyle123]

Are there any ActiveX controls in the workbook?

 

[sarahjane874]

Thanks for the fast reply. No, there are none

 

[RoryA]

What references are checked, and which line of code is highlighted when the error occurs?

 

[sarahjane874]

These references are checked in:

- Visual Basic for Applications
- Microsoft Excel 15.0 Object Library
- OLE Automation
- Microsoft Forms 2.0 Object Library
- Microsoft Scripting Runtime

No code is highlighted. The code ran successful with no error, it edited the file and saved it. When I want to open the edited Excel file (after the code had runned), the error occurs.
I tried the same code on another Excel file and everything worked.

I have no clue why this file crashed. All the files, who are edited by the Code are very similar.

 

[RoryA]

If you get a compile error you should have the option to debug unless you locked the project?