-
Excel automation error on VBA Code modification using VBA
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules