Hi Mike,
Thanks again for giving me a working example. It was very helpful and I was able to adapt it to my folder structure and it works.
I was wondering if you can give me an idea how I can modify your example?
In your working example, it is looping through the spreadsheets to see if it has any of the following sheet names in the excel file.
Is it possible that when looping through the excel file, before it moves it to a
BAD folder because it does not have the sheet name Library or School that it checks if the sheet name falls with a list of name and I could replace it with the proper respective sheet name?
For example, the excel file has the following sheet name
"Public Lib " or
"Lib System", if it sees that sheet name, I would like to rename the sheet name to
"Library" as for the same goes for
"Public H.S. " or
"Elementary School", I would rename the sheet name to
"School", then the file would be moved to the
GOOD folder.
How could this be achieved from your working example?
Appreciate it.
-Chuck