How do I save an excel spreadsheet in a different format

[iscrsb]

I am splitting an excel spreadsheet into smaller sheets by account number. I am saving it with the extension .xls. It is saving as a type of worksheet but the software that it needs to be imported into only excepts a format of workbook. How do I specify specific versions of Excel on the save?

[Deana]

The Excel SaveAs method allows you to specify the file format: http://msdn.microsoft.com/en-us/library/office/ff841185.aspx

Reference:
http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/OLE~with~Excel+Excel~and~SaveAs~Method.txt
http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/OLE~with~Excel+Save~XLS~file~as~a~CSV~file.txt
http://techsupt.winbatch.com/webcgi/webbatch.exe?techsupt/tsleft.web+WinBatch/OLE~COM~ADO~CDO~ADSI~LDAP/OLE~with~Excel+Automating~Excel~Tutorial.txt