Need to help to save data from Excel to XML

[spycein]

Hello Everyone,
Need help to save excel sheet data in xml format.
For example, i need to save the data from Sheet1 of my workbook in xml format seperate file.
From the following range, i can only copy "Column A" data but i need to expand the range of the column.
Range("A1:A" & Sheets("Sheet1").Range("A" & Rows.Count).End(xlUp).Row)
Kindly help me on this.
Best Regards,

 

[kennypete]

@spycein you seem to be creating duplicate posts. You asked me the same thing in the ongoing post, which I have answered.

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.