Our files are being moved to another drive and directory so that is why I need to replace any code in any excel files that reference the old directory and drive.
Actually what i am trying to do is to search all the modules in each excel file for a text phrase and replace that phrase with another. I can open each excel file individually, pull up one of the modules, and do a find and replace on the phrase. I was hoping to write a batch job in access...
We have 4500 differnt historical excel files that we need to be able to search through the vba code and replace some text when found. The text would be the same in each excel file. We recently moved to a different network drive and there are about 64 references to the old drive in the code...
We have 4500 differnt historical excel files that we need to be able to search through the vba code and replace some text when found. The text would be the same in each excel file. We recently moved to a different network drive and there are about 64 references to the old drive in the code...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.