links

  • Thread starter Thread starter bob engler
  • Start date Start date
B

bob engler

I have an application that has WBs in a base folder. Some of
the WBs are linked. The WBs are then copied to other folders.
Is there a way to set the links in the Base folder to refer to WBs
in the same new folder and keep that same relationship after copying
them. IE: WB1 A1 is linked to WB2 C5 in the same folder. After
the copy, WB1 A1 is linked to WB2 C5 in the new folder.

Thanks....
 
Bob

If both workbooks are open and WB2 is copied using File - SaveAs, then the
links should update. Otherwise, I don't think so.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Message for Bob Phillips 2
macro to copy data to master workbook. 2
Last row in a particular sheet / workbook 4
Select / Copy / Paste 6
Open a workbook using a stored name 3
Run-time error '1004'??? 6
check Wb is open and copy data to it 10
Needed Macro and Function Help 4

Back
Top