Thread: Creating Column Headings from XML Categories When Linking Data Wit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimR JimR is offline
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 With QuoteReply With Quote