Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Word Excel Links
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating Word Excel Links
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. -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "Partho" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating embedded links in Excel | Excel Worksheet Functions | |||
Updating links in Excel 2002 | Excel Discussion (Misc queries) | |||
Updating Links on Excel | Excel Discussion (Misc queries) | |||
updating links in Excel | Excel Discussion (Misc queries) | |||
Updating Links to Other Excel Files | Excel Worksheet Functions |