karthikeyan.kannan
New Member
- Joined
- Jan 27, 2009
- Messages
- 3
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
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