Windows Scripting
I need a script by the end of today to do the following.
search through folders I specify and then any subfolders listed within that folder
find all Excel files listed if it finds the text that I want replaced it will replace it. Save it and close
the file. so when I go to open the file it will already be changed.
search through folders I specify and then any subfolders listed within that folder
find all Excel files listed if it finds the text that I want replaced it will replace it. Save it and close
the file. so when I go to open the file it will already be changed.
ASKER
I have the script to replace the text but I need the part that will search through the folders and subfolders. I dont want to have to pay for the software as it will be a one time deal.
So you will need to specify a list of "root" folders to scan, they aren't all under one parent?
And what file extension(s) do you want it to look for, just XLS, or others as well?
~bp
And what file extension(s) do you want it to look for, just XLS, or others as well?
~bp
ASKER
yes they are, it will be as an example c:\scripts\accounts\subfol
ASKER
Just XLS files
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Billprew I will try this tomorrow and let you know how it turns out. Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
the script didnt work how I wanted, but these guys put forth the effort.
This will do what you are looking for. It can be done in VBScript but might be a little hard.