Macro to change any linked external workbooks to active workbook regardless of drive/path?

I need a macro that does the function below, but does not reference specific file names, paths, or drive letters. It will need to change links to all external workbooks to the active workbook.

Please Login or Register  to view this content.

I thought that the NewName could reference ActiveWorkbook, but I have no idea how to go about changing the link name if I'm not referencing the specific currently linked file by name.

Any help would be greatly appreciated!

I'm a little confused what you exactly want done here? You have links to X amount of other workbooks in a workbook, and you want those links to be updated to the active workbook?

Originally Posted by Medpack

I'm a little confused what you exactly want done here? You have links to X amount of other workbooks in a workbook, and you want those links to be updated to the active workbook?

Yes exactly. I have about 50 named ranges used to populate drop down boxes throughout the workbook. A single page containing dynamic arrays is used to organize input data for named ranges. Since a few worksheets are copied and modified for different projects, the named ranges link back to the original workbooks, rather than the current workbook.