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?
ASKER
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?
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
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
ASKER
how would I create a macro that applied the map then imported the data?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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