PDA

View Full Version : Excel automation error on VBA Code modification using VBA



nikki333
05-20-2019, 12:02 PM
Hi Folks

I'm (still) trying to implement a code update routine for my project. I.e. A macro that looks up the newest folder within a dedicated backup folder that contains all VBA Code components as .txt
Then it should replace all of the Code components in the active workbook. (I know I've started a thread before, but i can't find it anymore, sorry for that).

The exporting works just fine, but the issue is with the importing. I've found that the importing wants to show a message (translated from German like: "Shall we apply the changes to 'Workbook xyz"). I found this error message in the Windows Events log (Excel doesn't give me a clue, only a crash without info). And I'm suspecting this to be the reason for excel to crash right after.

Does anyone have an idea to resolve this?

Cheers, Ted