Hi, I have an XML map and I need to update the source and refresh.
The result is currently in a table. I usesd developer > source > XML Maps > Add and then dragged the elements into the sheet to create a table.
How do I do this via VBA? All the elements will be exactly the same.
So far I've tried
But this does not work properly. It updates some parts of the new data, but not all of it for some reason.
I have also tried
But then all the elements are not mapped and I don't know how to add the to the table.
Thanks for you help!
The result is currently in a table. I usesd developer > source > XML Maps > Add and then dragged the elements into the sheet to create a table.
How do I do this via VBA? All the elements will be exactly the same.
So far I've tried
Code:
mYQuery = "http://example.myxml.com/feed.aspx?id=12
ThisWorkbook.XmlMaps("MyMap").Import (myQuery)
I have also tried
Code:
ActiveWorkbook.XmlMaps("MyMap").Delete
ActiveWorkbook.XmlMaps.Add(mQuery, "search").Name = "MyMap"
Thanks for you help!