Search and Replace text strings within Macros
I am looking for a product or VBA code that will search
for a particular string in all macros or VB code within multiple Excel Files in multiple directories and replace it with another string. Example if I have the string "H:\ in multiple macros in multiple files and I want to replace it with a DFS name like "\\Continent\Country\City\Location\". Thanks very much in advance Chris |
Search and Replace text strings within Macros
Chris
I don't know of any ready made solution for you, but you could write your own. http://www.cpearson.com/excel/vbe.htm -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Chris Austin" wrote in message ... I am looking for a product or VBA code that will search for a particular string in all macros or VB code within multiple Excel Files in multiple directories and replace it with another string. Example if I have the string "H:\ in multiple macros in multiple files and I want to replace it with a DFS name like "\\Continent\Country\City\Location\". Thanks very much in advance Chris |
All times are GMT +1. The time now is 04:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com