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
Bookmarks