Convert selected file to XML and save.

[dhivya.enjoy]

Hi Team,

I developed a macro wherein you need to enter the required values for the columns and then on pressing the button the macro will run and generate a xml file.

The issue I face is when I press the button and xml file is generated and saved in the desktop, again on changing the data and running the macro error appears as below screen shot. This is because that when the output xml file is available in the desktop and trying to regenerate the output file, it generates with the same name in that case the error appears. But this should not be the case it should update or replace the xml file generated.

Also one more issues is whenever the xml file is getting stored it always look for my desktop location, my desktop location is hard coded in this. Not sure how to make this a generic one so that it will work in others pc too.


Please advise.



Capture1.jpg

Regards
Dhivya