Menu

Problems saving a worksheet with links to a New Location

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.worksheet.functions

Dave Peterson Dave Peterson is offline

Dave Peterson is offline

external usenet poster

Posts: 35,218

Default

Problems saving a worksheet with links to a New Location

You have a few replies to your other posts.

wrote:

Does anyone know how I can resolve this issue ... I have a directory which
contains 129 worksheets which have links to external data (in a Master
Spreadsheet) -- I need to copy these files into a New Directory, but kee the
Master Spreadsheet (which they are linked to) in the original location. If
I do a simple Cut & Past, the Reference Link to the Master Spreadsheet gets
moved to the New Directory (where the file does not exist), but if I open
the worksheet (in the original directory/location) and Save As to the New
Directory, the worksheet saved in the New Directory maintains its link to
the Master Spreadsheet in the original directory/location. I hope I've
explained this clearly.

Here's my problem -- it's a bit time consuming to have to open each and
every worksheet and Save As to the New Location -- I'm not sure if a Batch
File (or Dos Command xcopy) would solve this -- Is there some code I could
use to Open each worksheet, Save As to the New directory, Close, then
perform this on each of the .xls files in the original directory? If so,
could you please point me in the direction with an example of the code.

Example:

Files in C:\Temp (a.xls, b.xls, c.xls) Copied to C:\Budget

Many Thanks in Advance.

--

Dave Peterson

Reply With Quote

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
worksheet links	BAC	Excel Worksheet Functions	0	March 22nd 06 02:54 AM
Saving to a worksheet in another file...?	nickclingan	Excel Discussion (Misc queries)	3	February 3rd 06 05:14 PM
links in cells break and revert to user profile location	heathy	Excel Discussion (Misc queries)	0	October 24th 05 05:37 PM
Comparing a list to a Calendar worksheet.	PatrickL	Excel Worksheet Functions	0	August 25th 05 04:21 PM
Saving templates with links and formulas	Barb1	Excel Discussion (Misc queries)	2	February 8th 05 04:13 PM

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

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement