View Single Post
 
Old 01-24-2018, 02:23 PM
Fabulist Fabulist is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Sep 2015
Posts: 33
Fabulist is on a distinguished road
Default

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.
Reply With Quote