Dec 17 2023 10:21 AM
Dec 17 2023 10:21 AM
I started having problems last Wednesday 12/13/12. I have 2 spreadsheets that stopped running because of Automation error, Invalid forward reference, or reference to uncompiled type. and autosave. I believe by turning off autosave in Excel fixed one problem. But I am still getting Automation error, when I try to run the 2 spreadsheets above, I have tried change the VBA code, which makes matters worse. I have Win 11 Pro, Ver 23H2, 64-bit PC, Running Office 365
Dec 21 2023 02:20 AM
Automation errors can be caused by various factors, and it's not uncommon for issues to arise after updates or changes in the software environment. Here are some steps you can take to troubleshoot and resolve the Automation error:
Keep in mind that debugging VBA issues can be challenging, and it may require a combination of the above steps. Always make sure to back up your files before making significant changes to your environment. The text was created with the help of AI.
Otherwise you would have to have the VBA code and/or the VBA file (without sensitive data) to be able to say more precisely.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
Dec 25 2023 07:06 PM
I just wanted you to know that I tried everything that you suggested, and I had pretty much given up. But, one day the program started working again. This was after my system crashed and would not restart. So, I called Intel, and they suggested calling Microsoft to get my recovery key, which turned out to be 64 digits. I keyed it in, and everything started to work again. Even the VBA code that worked before started to work again. I wasted a lot of time on this and like I said before I was ready to give up. If appears, something had been corrupted, and by using recovery it straightened everything out. Also, all of the Automation errors have gone away. I have been running for several days now, hopefully my issue is fixed and will not come back.
Thanks for the reply, Ed Vagim.