Posted to microsoft.public.excel.programming

Mark[_22_] Mark[_22_] is offline

external usenet poster

Posts: 18

Replacing One Sheet in Several Files

Need to replace one sheet named "MKR15" in 40 different files.
The file containing the new copy of "MKR15" is "c:\work\source.xls".

A list of the file names (including paths) is in "filelist.xls" in cells a1:a40.

I'd like to write VB code to perform this operation.

Any suggestions?

Thanks, Mark

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replacing sheet causes #REF	Homer	Excel Discussion (Misc queries)	4	July 31st 09 07:59 PM
replacing Sheet	create_share	Excel Discussion (Misc queries)	1	August 1st 06 12:49 PM
Replacing sheet reference in multiple cells...	neilcarden	Excel Worksheet Functions	3	June 23rd 06 05:00 PM
Replacing text in Excel files on disk?	Desperate Don	Excel Discussion (Misc queries)	0	March 1st 05 04:23 PM
replacing just the sheet names within formulas	Jeanne Criez	Excel Worksheet Functions	1	January 4th 05 06:27 PM

All times are GMT +1. The time now is 07:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us