Hello again, it has been some time from this post.

The more I try to understand what I have to do to make your macro work the more wrong I am it seems. Is there maybe a step by step guide for super dummies so I can try to make your macro work?

'I think that is the Dummies edition! This is not for the faint-at-heart. Did you download the file at the end?

The macro attached to the post there is in a ready-to-run state, all you need do is unzip it then import it into the Word document, for which you
• press Alt-F11 to open the VBE
• click on your document's entry in the panel on the left
• choose File|Import File
• navigate to and select the unzipped file
• press OK
• save the document.
Done. That's essentially the same as what the instructions in the link tell you to do. There really is nothing to simplify.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thank you for getting back at this!

Excuse me I did not clarify, I did import your macro and run it, but nothing is happening; the macro runs and nothing changes on any linked item.

The files are like this:

Word file in:

C:\Users\Admin\Documents\Workstation\Audit Modules\Company A\END DATA\Report.docm

The Excel files linked on the Word file above are in:

C:\Users\Admin\Documents\Workstation\Audit Modules\Company A\Report.xlsm

--- The Report.docm needs to be moved below ---

C:\Users\Admin\Documents\Workstation\Audit Modules\Company B\END DATA\Report.docm

The Excel files linked on the Word file are in (same as before):

C:\Users\Admin\Documents\Workstation\Audit Modules\Company B\Report.xlsm

So it is a straightforward switch from Company A to Company B, but I guess I am supposed to change something because it is not doing anything as is.