EXCEL : Export in XML file format

tell application "Microsoft Excel"
save (open (choose file "Choose an Excel file")) in "test.xml" as XML spreadsheet
quit saving no
end tell

... or ...

tell application "Microsoft Excel" to save (open (choose file "Choose an Excel file")) in "test.xml" as XML spreadsheet
tell application "Microsoft Excel" to quit saving no

I'm using Excel to create an XML file from a text file. Do you know a better way to do it ?

Ahh, so your question relates to options for creating XML files, not better ways to drive Excel. That was not clear in your original post.

Ultimately, XML is nothing more than a structured text format. You can create an XML file by hand using the standard AppleScript write command, although you are responsible for properly formatting the data before you write it out.

Alternatively there are a few AppleScript OSAXen (extensions/additions) that are designed around working with XML. One is Late Night's XMLTools which provide AppleScript commands that can read, format and write XML within your script, without needing to use a whole separate program like Excel.

Are you saying your script doesn't work, and you're not sure why?
Or it works but you're wondering if there's a better way of doing it?

It isn't clear from your post