Copying Linked Excel & Word Documents

[Bagman2524]

Anyone know of a way to take an Excel-Word linked pair of documents, copy them to a new pair of documents that are linked, but don't have any links to the original linked document pair?

Nearly all men can stand adversity, but if you want to test a man's character, give him power. Abraham Lincoln

 

[SkipVought]

Hi,

So what's the process for creating the new Excel & Word documents?

Do you use any VBA code to do this? If so, please post your code.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Bagman2524]

Merely copying the existing documents and giving them a new name


Nearly all men can stand adversity, but if you want to test a man's character, give him power. Abraham Lincoln

 

[SkipVought]

Are the Excel linked to the Word or the Word linked to the Excel or both?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Bagman2524]

The Word document has specific locations that are linked to specific cells in the Excel spreadsheet. I doing "Save As" for each document into a different folder with a new name. I can't figure out how to break the links to the original two documents (Excel-Word pair).

 

[SkipVought]

How about being forthcoming about the specific description of the state of these files before and after you rename them, or else with your drip...drip...drip approch, you may be here alone. It's gonna take a VBA solution, so fuzzy words and fuzzy logic won't work. I need a data dump. Too much info is much better than too little info.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}