| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find And Replace
Greetings,
Is it possible to do a find and replace across multiple workbooks? Any help will be appreciated. -Minitman |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find And Replace
When I want to do something to multiple workbooks I write two macros, one to
Open and close each file in a directory, and the other to do the change. Just step through the directory one file at a time, open, do change, save, close.....open next file, etc. Vaya con Dios, Chuck, CABGx3 "Minitman" wrote: Greetings, Is it possible to do a find and replace across multiple workbooks? Any help will be appreciated. -Minitman . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find And Replace
Hey Chuck,
Thanks for the reply. Do you have an example of your two macros you could post? -Minitman On Thu, 28 Jan 2010 07:02:02 -0800, CLR wrote: When I want to do something to multiple workbooks I write two macros, one to Open and close each file in a directory, and the other to do the change. Just step through the directory one file at a time, open, do change, save, close.....open next file, etc. Vaya con Dios, Chuck, CABGx3 "Minitman" wrote: Greetings, Is it possible to do a find and replace across multiple workbooks? Any help will be appreciated. -Minitman . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| Find/Replace Event or Find/Replace for Protected Sheet ... | Excel Programming | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Using Find and Replace to replace " in a macro | Excel Programming | |||
| Replace method - cannot find any data to replace | Excel Programming | |||
Hybrid Mode
