linking twom excel documents both of which are often renamed

  • Thread starter Thread starter tracie
  • Start date Start date
T

tracie

Does anyone know how to create a stable link between two
Excel workbooks that are often renamed/resaved?

For example, workbook A contains some sheets that are also
in a workbook B. Whenever workbook A is updated I want
the changes to flow through to workbook B BUT the catch is
that whenever workbook A and B are changed, they are
resaved with a new name.
 
If you can get the two new document names into VBA strings, you might be
able to go through the workbooks after saving and update the references with
the new doc names. Your code would have to go to a cell with a reference,
find the wkbk name and save it as a string, then do a Find/Replace.

I'm not good enough to give you the code for finding the workbook name in a
current reference right now - it would take me a while to find it (and I'd
probably wind up asking here if I got stuck!) But that's how I would
approach it.

Sorry I wasn't more help.
Ed
 
Does anyone know how to create a stable link between two
Excel workbooks that are often renamed/resaved?
Click to expand...

You'd have to use Visual Basic, probably an event based thing that would
fire whenever you saved the document, and would go into the other workbook
and make the appropriate corrections.
 
If you do all your saving (file|saveAs for the rename) with both workbooks open,
then I think the links will adjust (make sure to save both workbooks).

If you have one of the books closed, then it won't know about your name changes.

If you do lose synchronicity, don't call the Police, try Edit|links and point at
the correct workbooks.
 
Back
Top