View Single Post
 
Old 06-18-2020, 01:47 AM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

OK,

There are two ways to do what you are asking:
1. Use a VBA userform to query the external xml file source and then display the form. The code can then write that info to either bookmarked ranges, document properties or unlinked Content Controls.
2. Embed the xml file inside the Word document itself and use linked Content Controls to display this information automatically. If you update the xml source content, you could use a macro to overwrite the embedded xml file inside the Word document.

My preference is to choose option 2. With that option, there is no need to also do the VBA Userform as you can edit the attributes in the embedded XML via the Content Controls or replace the xml if the source changes.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote