Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-18-2020, 01:47 AM
Guessed's Avatar
Guessed Guessed is offline Filling data with XML Windows 10 Filling data with XML Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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
 



Similar Threads
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
Filling data with XML matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
Filling data with XML New to Excel - Filling out data The Accountant Excel 2 12-16-2013 12:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft