Text only | Text with Images

WinBatch® Technical Support Forum

All Things WinBatch => WinBatch => Topic started by: iscrsb on February 03, 2014, 05:28:33 PM

Title: How do I save an excel spreadsheet in a different format
Post by: iscrsb on February 03, 2014, 05:28:33 PM
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?
Title: Re: How do I save an excel spreadsheet in a different format
Post by: Deana on February 04, 2014, 09:31:28 AM
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
Text only | Text with Images