General information
Category:
COM/DCOM and OLE Automation
>>I think you can use SaveAs rather than Save, but it's been a while since I did Excel automation.
>>
>>>The client's program uses Office Automation to prepare Excel spreadsheets for email to customers.
>>>Some of the client's workstations have the latest Office version and create spreadsheets that cannot be read by earlier versions (I can't read them with Office 2003)
>>>Is there some way to control the version that is created ?
>
>It looks as if SaveAs is the answer, but I can't get it to work.
>It should accept another parameter for file format.
>I found a list, but no matter how I try to pass it, I crash
>
>This is the latest try, and it crashed
>
> ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls","xlExcel5" )
Try:
xlExcel5 = 39
ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls",xlExcel5 )
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only