I am running a script on Windows 7 using the Excel application in MS Office 2010.
I wrote a script which uses the 'Visual Basic' command "xlSheet.SaveAs filename" and it works OK. however, it always saves the Excel file in the
*.xlsx FORMAT.
I need to be able to do the 'SaveAs' but with the OPTION to save in the Excel 97 (older) format of *.xls, but do not know how to get at hose 'Type' OPTIONS in the 'SaveAs'
Can you Help?
Thanks,
John