Automation error - Excel VBA

Filasol

New Member
Joined
Jun 23, 2022
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
Hi All,
I'm new here, and first I tried to find a similar topic, without success. (Sorry for my English :-) )
So... I have a robust, complex and intricate Excel workbook with about 15 sheets and userforms, macros etc.
I developed it in the last 4-5 years for my small business, as a management application.
It worked full perfectly, I used it without any trouble.
In the last few weeks, when I start this workbook, the Excel opens, sheets are opened, but if I try to run a macro (as I did it in the past without problem), an error message appears: "Automation error". Nothing else. There are no error code, explanation - nothing. Automation error.
If then I press "OK" button, and try to restart the same macro (it would open a userform, that normally shows all data of the selected row of the sheet, in a formatted order and surface), the userform opens, first 4-5 data appear, but all of other fields are empty.
If I close this userform, press "SAVE" to save the file and start again this same macro, it runs normally.
I tried to wait a little after starting the file, press the SAVE without starting any macro, and I see it sometimes helps, sometimes not.
I use Excel 2016 English (although the error message also contains a Hungarian sentence, which means: "An exception occurred") on Windows 10 PRO English (64 bit) on an Asus notebook.
This situation is very irritating, I can't start my work and I have to wait, press SAVE, open and close userform etc. to start the app normally.
The file is worked normally in the past and has not been changed, expanded, modified. There are no connection to other workbook or network, no autostart process in the background during opening this file etc.
Has anybody any solution? :-)
Thank you...
 

Attachments

  • automationerror.JPG
    automationerror.JPG
    15.8 KB · Views: 15

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
All you can do now is Debug your macro to see if you can find what line of code generates the error.
By the way, how come, if you have a 2016 English version, you get a Hungarian error message ? By any chance, have you recently tried to install a newer version of Office ?
 
Upvote 0
All you can do now is Debug your macro to see if you can find what line of code generates the error.
By the way, how come, if you have a 2016 English version, you get a Hungarian error message ? By any chance, have you recently tried to install a newer version of Office ?
I don't understand this situation: all macros are exactly the same as before. No changes or modifications have been made, but what used to work without problems is now generating an error. In addition, English Excel sends a bilingual error message on English Windows (Hungarian is my native language). Another weird thing is that I don’t have to do anything, just wait or save the file after opening and it already works fine. I don't have to intervene, it will resolve itself. So I don’t really know what could be the cause of the problem.
 
Upvote 0
I would try this next step: from Control Panel / Programs and Features / right click Microsoft Office / Change / Online Repair.
As last option I would create a new file and Copy/Paste to it all sheets and macros from the original file.
 
Upvote 0
I would try this next step: from Control Panel / Programs and Features / right click Microsoft Office / Change / Online Repair.
As last option I would create a new file and Copy/Paste to it all sheets and macros from the original file.
OK, I'll try it.
Thanks for your tips.
 
Upvote 0

Forum statistics

Threads
1,223,895
Messages
6,175,257
Members
452,625
Latest member
saadat28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top