Hello Dear
Two ways you can import your XML Data in your Workbook
1. Manually Importing XML Data
2. Programmatically Importing XML Data
Now how to…….
1. Manually Importing XML Data:
1. Start Excel and then click Open on the File menu.
2. In the Files of type list, select XML files.
3
Hi,
I recorded a macro in Excell 2007 to import an xml file.
As I wnet through the steps manualy everything workeed fine.
When i try to run the macro I get an error.
Here is the macro I recorded:
Sub xml2()
'
' xml2 Macro
'
'
Range("A1").Select
ActiveWorkbook.XmlMaps("SecScan_Map").Imp
