Loop Through all files in a folder and use the same macro to edit each one.

**dj59** · 09-17-2012, 04:04 PM

I am using the PERSONAL.XLSB to store my macro that I want to use on each file in a specific folder.
It works all the way through the first file, then I get I get a runtime error 91, object variable not set. It stops at this line:

Please Login or Register  to view this content.

Any help will be appreciated.
Here is the entire code:

Please Login or Register  to view this content.

**JBeaucaire** · 09-17-2012, 10:40 PM

It doesn't appear the files are being explicitly opened. Something like this:

Please Login or Register  to view this content.

**dj59** · 09-18-2012, 09:28 AM

I am trying the code you posted, however now I get the error message; "runtime error 1004 method add of object sheets failed".
In my original code I was beginning with "Option Explicit", I apologize for not having that in my posted code.
Thanks for looking at this.

**JBeaucaire** · 09-18-2012, 12:47 PM

My apologies, the code above is corrected.

**dj59** · 09-18-2012, 04:08 PM

Excellent! Thank you.

**JBeaucaire** · 09-18-2012, 06:56 PM

I have marked this thread solved for you.

In the future please select Thread Tools from the menu above and mark the thread as solved. Thanks.

Loop Through all files in a folder and use the same macro to edit each one.

LinkBack

Thread Tools

Rate This Thread

Display

Loop Through all files in a folder and use the same macro to edit each one.

Re: Loop Through all files in a folder and use the same macro to edit each one.

Re: Loop Through all files in a folder and use the same macro to edit each one.

Re: Loop Through all files in a folder and use the same macro to edit each one.

Re: Loop Through all files in a folder and use the same macro to edit each one.

Re: Loop Through all files in a folder and use the same macro to edit each one.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions