If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problems saving a worksheet with links to a New Location
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. |
#2
|
|||
|
|||
Problems saving a worksheet with links to a New Location
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Saving to a worksheet in another file...? | nickclingan | General Discussion | 3 | February 3rd, 2006 05:14 PM |
Saving worksheet as webpage | Aramis | General Discussion | 1 | January 9th, 2006 10:26 PM |
Can't move worksheet after saving (mac) | funkster99 | General Discussion | 1 | December 31st, 2005 12:32 PM |
update links in an individual worksheet | [email protected] | Links and Linking | 3 | August 19th, 2005 01:46 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |