Hi
I need to write a Macro to import XML data into a spreadsheet.
I will need to import upto 100 different xml forms into a spreadsheet from one location, but i can't seem to get the mapping to work in VBA
Below is the bit i am having trouble with
Dim mapContact As XmlMap
Dim strXPath As String
' Specify the schema map to use.
Set mapContact = ActiveWorkbook.XmlMaps("Project Register")
' Specify the first element to map.
strXPath = "myFields"
' Map the element.
Range("A5").XPath.SetValue mapContact, strXPath
am i doing something obviously wrong or am i missing something, please help.
Much Appreciated
I need to write a Macro to import XML data into a spreadsheet.
I will need to import upto 100 different xml forms into a spreadsheet from one location, but i can't seem to get the mapping to work in VBA
Below is the bit i am having trouble with
Dim mapContact As XmlMap
Dim strXPath As String
' Specify the schema map to use.
Set mapContact = ActiveWorkbook.XmlMaps("Project Register")
' Specify the first element to map.
strXPath = "myFields"
' Map the element.
Range("A5").XPath.SetValue mapContact, strXPath
am i doing something obviously wrong or am i missing something, please help.
Much Appreciated
