ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating Column Headings from XML Categories When Linking Data Wit (https://www.excelbanter.com/excel-programming/346955-creating-column-headings-xml-categories-when-linking-data-wit.html)

JimR

Creating Column Headings from XML Categories When Linking Data Wit
 
When I link XML data into a spreadsheet with drag and drop from the XML
Source window the data gets nice headings based on the XML categories but if
I link the data using the VB commands that actually create a list first and
then links the XML, I get headings of Column1, Column2, etc. Is there any
slick way to get these column headings inserted?


All times are GMT +1. The time now is 12:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com