Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Controlling the version of Excel
Message
 
To
02/05/2013 20:45:29
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01572404
Message ID:
01572591
Views:
62
This message has been marked as the solution to the initial question of the thread.
>>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
Map
View

Click here to load this message in the networking platform