Hello,
I am running a looper. I have used this code for probably the last 10 years. All of a sudden it is throwing an automation error - exception occurred and then excel shuts down. I am running 64bit 2016 excel as of a few months ago. Any ideas if there is something in the code that is causing this?
Please Login or Register to view this content.
If the macro has not been changed and has been working for the last ten years, it is either a problem with the list of files or it is something to do with the file that is being processed.
Put some debug statements in the loop and print the loop number (I), and strFileName
I would suggest that you manually step through the loop as, if Excel crashes, you'll lose the debug output.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
what's weird is sometimes it bombs on the 20th file. other times it will pass that file and maybe go to 100. it seems random. It is the same files it is looping through.
Code looks ok. Not much to go wrong.
Maybe try running it after you've just rebooted your machine. Clean environment, just Excel loaded.
Not it looks like it is running ok. Crazy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks