VBA in Excel to >> update links in word file then save it as PDF

[Ambiguooous]

Hello,

I have an Excel file with some data entries (20 different variable cells) these data are copied & pasted special in a Word documents (in different portions) every time i change in the data in the Excel sheet i have to go to the word document and update the links there and then print the document as PDF ...

I'm looking for a VBA in the Excel file that will open the existing Word document after press a bottom then automatically apply the updates to the links, and then convert it (print or save as) as a PDF




Many thanks in advance for the consistently great help from you all ....

 

[Ambiguooous]

Anyone can help on this

 

[Ambiguooous]

Anyone can help on this

 

[Ambiguooous]

Up

 

[Ambiguooous]

...