Process Multiple Files at Once

I have a requirement to validate "price" parameter in a file. I have coded a macro that does this. However I have been told that there are potentially over 50 files on which I would have to repeat the process, which can be time consuming. I was planning to create an text/excel file to store the names of those 50 odd files that I would like to process from a folder containing over 200 files. Is it possible to code a macro that can read this new text/excel file and repeat the process for every file?

Appreciate any help!

Regards,
DD

dashingdude,

I'm sure there is probably a more elegant way of doing this, but here is how I would probably do it. This code is set up to use a list that would have the file path, file name, and sheet name put in different columns. I did it this way because I have no idea if all of your files are in the same folder and if they are then this can be simplified somewhat. I coded for worst case scenerio.

Please Login or Register  to view this content.

You will need to play around with this and adjust it to fit your needs, but maybe it will get you headed in the right direction. I threw this together rather quickly based on the information you gave. It may be able to be streamlined a little more based on your exact situation.

dashingdude,

Hope it works and please post back to let me know.