changes to the same worksheet within multiple files

[Guest]

I have a master workbook that has 9 different workseheets
in it. The master has been saved to over 200 files.
Certain things need to be changed within the 200 files on
certain worksheets. Is there any way to make changes to
ALL 200 sheets at one time, aside from a macro, or
changing each affected worksheet individually?

 

[Don Guillett]

AFAIK you would have to use a looping macro to open each workbook>make the
changes>save & close.

 

[Ron de Bruin]

You need a macro

Look at this example
http://www.rondebruin.nl/copy4.htm

 

[Guest]

Thanks Ron, I appreciate it!

-----Original Message-----
You need a macro

Look at this example
http://www.rondebruin.nl/copy4.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl





.

 

[Guest]

Thanks Don, I appreciate it!

-----Original Message-----
AFAIK you would have to use a looping macro to open each workbook>make the
changes>save & close.

--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[Guest]

Ron,

You are the BEST!!! Quick question, once I set up the
macro and perform the needed changes, if I "deep six" the
macro, will the changes hold? I don't want users to be
involved with the macro.

 

[Ron de Bruin]

Hi

The users don't see the macro
The macro is in the master workbook

You copy a range or sheet from the master workbook to all workbooks
and save each workbook in the loop with this line

mybook.Close True