[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5280
  • Last Modified:

Importing XMl into Excel using a XSD map

I am importing XML files into an Excel spreadsheet.  I open the XML source pane and open an XML map. I drag the folder in the source pane over to the cell where I want the data to begin and the cells are circled in blue.  I then import data into those cells.  I then delete the XML map and close the file.  My question is: do I need to delete the map each time or is there an easier way of doing this?
0
Dier02
Asked:
Dier02
  • 3
  • 2
1 Solution
 
kacorretiredCommented:
Maybe help
Importing XML Maps, XML Lists, and Dynamic Chart Sources in Excel 2003
http://msdn2.microsoft.com/en-us/library/aa203727(office.11).aspx

wbr Janos
0
 
Dier02Author Commented:
So if I hyad an existing spreadsheet and an existing schema or map and my map was called BSC how would I attach a button to my task bar in Excel 2003 and then attach the code to import XML data according to this BSC map?
0
 
kacorretiredCommented:
How to create a taskbar:
RightClick Menu / Customize
New  -> New Toolbar  Toolbar Name: MyToolbar  OK

Select Commands tab   Macros  and drag  CustomButton onto MyToolbar
Right click Custom Button: you can rename and change button image
Close Customize
Click CustomButton on MyToolbar -> Assign Macro and you can select the needed macro to this button




0
 
Dier02Author Commented:
how would I create a macro that applied the map then imported the data?
0
 
kacorretiredCommented:
read
Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET
http://msdn2.microsoft.com/en-us/library/aa203723(office.11).aspx

I hope this help you

wbr Janos
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now