VBA - Copy XML code from excel worksheet and save to an XML file without delimiters

Hi,

I hope someone can help, I have run out of ideas :-)

Thanks in anticipation.

Problem:
I am using VBA to automate a process of reading formatted xml code in Excel
then copying the XML code from the worksheet to Notepad and saving it as an XML file.

The VAB works fine, however the save "XML" has a double quote (") as a leading and trailing delimiter for each xml line plus where there are already quotes in the string, they are being doubled.

Already attempted:
I have tried to remove the extra double quotes for each string as I write it out, but that does not work properly.

I have attached an example worksheet with the formatted xml and also the resulting notepad file.

I need this automated but can't come up with a solution

Thanks Bernie, I will let you know the outcome tomorrow evening. :-)

Hi Bernie,

Just to let you know your solution worked perfectly.

Thanks for your help :-)