Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace numeric strings in larger text strings | Excel Worksheet Functions | |||
How do I filter or search mulitple for text strings? | Excel Discussion (Misc queries) | |||
Macros & search /replace | Excel Worksheet Functions | |||
How do I search and replace text in a textbox in Excel? | Excel Discussion (Misc queries) | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) |