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