Re: appExcel.ActiveSheet.SaveAs how to save in Excel 2003
Fear I have an answer for this. You should be able to just switch the .csv in my code below with a .xls or add an &".xls" to the end of the filename in your script.
If you' use the same vb type code I have below, you can specify the file extension where you specify the file name and it works. There might be something like that on whichever code protocol you are using too. (I hadn't played with this script in a month, but I pushed the button just now and the file came out with today's date in the name and .csv format.)
Here is macro code I have on an export to file button in one of my files.