Thanks, Tore
That's helpful


>?oExcel.version will give you the version number. Check here for more info. http://en.wikipedia.org/wiki/Microsoft_Excel.
>
>>Thank you Craig, Yuri and Tore.
>>
>>I found the .h file values and it's working now.
>>
>>Is there any way I can relate the excel # to a year?
>>Most people say Office 2003, etc. and I'd like to know which excel # relates to which version of Office.
>>
>>
>>>>>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" )
>>>

ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls",xlExcel5 )

>>>Or, if you have forgotten to include the .h file:
>>>

ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls",39 )