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.
|