Updating Word Excel Links

  • Thread starter Thread starter Partho
  • Start date Start date
P

Partho

This is strictly speaking a Word query, but I thought the
wise men and women of this newsgroup might have some
answers!

I have a Word document with a large number of links with
an Excel spreadsheet. I have now updated the Excel source
spreadsheet and re-named it. I am trying to develop a Word
macro to edit the links in the Word document, ie replacing
the old Excel filename with the new one. The Excel source
cells are all named ranges with names like Cell1, Cell2,
Cell3 etc etc.

Any guidance with this would be greatly appreciated. TIA.

Regards,
Partho
 
Partho,

The simplest solution is this, if it is still possible.

Reopen the original excel document with the original name that your word
file is linked to WHILE the Word document is open, then resave the excel
file under the new name, your word links should update automatically.
 

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

Excel spreadsheet to Word document 1
VB To Re-Name Worksheet Name 3
Saving a Word document as PDF from en Excel macro 2
Using Solver with multiple ranges (Excel 2003 sp2) 4
XLL ('C' extension) question 1
update links in Word from Excel 1
Saving Changes to Excel App 1
Automatically linking data from Word into Excel 2

Back
Top