Forum Discussion
heylookitsme
Jan 26, 2021Iron Contributor
Running Macro Causes Reference File to Save somewhere else
I can't seem to replicate this error but it happens at least once a week. I open a file where I created some script. Does not matter if it is an older file or a newer one and I get the dreaded error ...
heylookitsme
May 19, 2021Iron Contributor
I am sure someone has an answer to this issue. It just happened again to me on three separate occasions. Files I have used for a few weeks or months work and save just fine. Then one day I go to save and get the dreaded Excel has found an error and is unable to save this file. We can repair blah, blah blah, then go to repair and save in different location and same error. Looping like an endless EDM concert. When I go into my VBA the modules are solid white, the project modules are there and will let you select them but no code in the module. When I try and select the reference library, nothing will happen, can't access it now. However, when I open the file in Safe Mode I am able to access the modules and Reference Library where I see Visual Basic For Applications reference file location is showing C:\Users\myname\Documents\ where I have the workbook itself saved. The library reference is normally located in the Microsoft shared\VBA\VBA7.1\VBE7,DLL which is where the file is currently it is not in my documents folder. Somehow, Microsoft has changed that reference library file but not actually placed the file there. This is crazy... If anyone runs into this issue HERE IS THE TEMPORARY FIX... Close the file and loose your changes you made. Close anything in Excel you may have opened. Then while holding the cntrl button select the Excel Application and a box will pop up asking if you want to open in Safe Mode. Say Yes. This will disable macros but still allow you to have access to it. You won't need to access this most times this occurs and you can simply save the file. Close it and re-open it (not in safe mode) and the file works again. Maybe for a few days or months but it will probably happen again at some point without any reason as to why.
- heylookitsmeMay 21, 2021Iron ContributorI was truly hoping to get some support in this community but I guess I will take my questions to MrExcel community instead.