VBA - Need Help Changing the Source of Information

[Jhouston]

This is the code that has been written. The original writer has left the organization and I need to update the source location.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

There is no code here that actually references any location. What do you mean by "source location"?

MyName is set to the path of the workbook containing this code, but it is never used for anything. There is no hard-coding of a location.

Maybe it would help to show all the code.

[Jhouston]

My apologies as it didn't copy over completely.

See the full code below.

Please Login or Register  to view this content.

[6StringJazzer]

The code cycles through all of the files that are in the same folder where this workbook is. All you have to do is put this file into the same folder with the files you want to work on.

[Jhouston]

It worked! Thank you very much.

[6StringJazzer]

Glad we solved that without code changes! If you want to modify to work on files in any folder the user chooses, that could be done too. Come back to ask if you need that.