![]() |
#5
|
||||
|
||||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Filling in cells based on 2 other cells data | Dawindle | Excel | 4 | 11-10-2018 07:40 AM |
filling in blank cells with data from cell above | RayK | Excel | 1 | 01-12-2017 04:14 PM |
Wierd... "cell" started auto filling with data from other cells I double click on. How stop it?! | KerryOn | Excel | 2 | 08-10-2015 08:41 PM |
![]() |
timomaha | Excel | 1 | 09-12-2014 07:51 AM |
![]() |
The Accountant | Excel | 2 | 12-16-2013 12:32 PM |