View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika Dick Kusleika is offline
external usenet poster
 
Posts: 179
Default 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