Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column Data to Appear as Column Headings in Another Sheet Monk[_2_] Excel Discussion (Misc queries) 3 November 27th 08 09:47 PM
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
column headings with data starting in row 1 Mrs. E. Excel Discussion (Misc queries) 2 June 10th 08 05:51 PM
How to keep column headings from being sorted with data? oldockbunny New Users to Excel 2 October 26th 06 07:46 PM
Create Headings from Column Data alphag_25 Excel Worksheet Functions 1 July 2nd 06 10:38 AM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"