Basically, I’m looking for a macro that would save my Excel File to existing XML File whenever data is refreshed in my Excel. I have an XML mapped Excel file which would have data from my source file. So every time my excel file gets data from source file, it has to be saved to XML data file. The whole process has to be automated without me opening the Excel file to save it as XML. Remember, the excel file will not be opened manually at any point. So the macro should be written in such a way that it opens the file and saves it as XML, all by itself. Thanks in advance for your response.