Importing XML into EXCEL

[karthikeyan.kannan]

Hi All,

I have created my customized XML view in my excel using XML Source pane and I have saved that excel for my use. My requirement is to validate the data in the XML files and I am doing it via excels. So each time I am importing the XML into the excel and after validation I am closing the excel without saving and re-opening the excel to reload a new XML file for my next validation. Is it possible to create a macro to clear all the stuff that imported during my last validation and keep the excel ready for next XML file without closing and opening the Excel.

Any help is greatly appreciated!

Thanks,
Karthik

 

[StevenD]

Hi Karthik,

Not sure exactly what you mean but this macro will refresh the xml information.

Dim myXML As String
myXML = "myxmlname" 'CHANGE THIS TO THE NAME OF THE XML AREA
ActiveWorkbook.XmlMaps(myXML).DataBinding.Refresh

HTH