A Question About Changing File Extention With VBA

[NewYorkFashionToGo]

Hello, hello, I am trying to come up with a work around, for a problem I am having. I am trying to create an XML Feed to feed into endicia. And it does not format properly for exporting in XML to feed into Endicia, I am completely lost with the schemas in XML that is a new beast to deal with and learn....
, I have tried something else and it works perfectly fine. My problem is I dont know how to write the code for what I would like to accomplish,

The goal is I export and save my file as .txt extention and without opening this new file , change the extention to XML and My application works Fine...... I been searching the boards trying to figure out how to change this using code. My macros arent taking it for me to get any information. I am relativly new to VBA and have several books also I looked through and Not finding a simple solution to do this. Does anyone know if there is a way to change it in this manner, Just to get it up and running, until I can figure out how to configure the schemas properly?

Again all I would like to do is Change from myfile.txt to myfile.xml using VBA code without opening the file.

Thank You!

 

[JerryKlmns]

Old good VB statement

Name "C:\myFile.txt" As "C:\myFile.xml

 

[NewYorkFashionToGo]

Thank You so Much That works beautifully, Just what I was looking for.