Find And Replace
 

Greetings,

Is it possible to do a find and replace across multiple workbooks?

Any help will be appreciated.

-Minitman

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
.

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
.