The VBA code that I posted was tested and it worked for me.
(I may have an “add appropriate extension” option selected somewhere)
Also, with Mac’s, the file extension is just a part of the name, files can be opened and worked with or without extensions.
If you look in the VB Editor’s Object Browser, keyword xlFileFormat will show a list of file format constants, like xlCSV and xlWorkbookNormal
see 13 in this thread Mike
With script you can have the same problem as in your VBA
If the format and the extension not match you can’t open the file that you save
My VBA code avoid it no, like you see that stephan also do in his script
See my function here
http://www.rondebruin.nl/mac.htm#GetSaveAsFileName
I think it is a good thing to consider the options for export in this matter -cross plattform compatibility, MsWindows relies on the file extension.
I am not saying this to you per se, mike. 