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...
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...