>>>I have both MS EXCEL 95 AND 97 on my desktop.
>>>My application use to work fine calling MS EXCLE 95.
>>>( Take a saved MS EXCLE 95 Spreadsheet and save it into a VFP general field.
>>> Then allow a user to open the spreadsheet from VFP in MS EXCLE 95)
>>>
>>>Now it calles MS EXCLE 97 and doesn't open or close EXCEL properly.
>>>
>>>How can I get VFP to call MS EXCLE 95 ?
>>> -- OR --
>>>How can I get VFP to work properly with MS EXCLE 97?
>>For short term quick fix you could install Excel95 after Excel97. For long term change your syntax to new excel97 syntax (vbaxl8.hlp).
>>Cetin
>Thanks, I'm on the road to recovery.
>I like the long term plan. Do I have to do something special for VFP. It doesn't like Excel97 varables?
Syntax between excel95 and 97 has changed somewhat. In files section you can find Excel97 object model. ie: autoformat(11,1) works in Excel95 blows in excel97 ( ie : counterpart -> .chartwizard(.range(.cells(1,1),.cells(4,3)),-4099,5,2,0,1,1,"","","","")).
Cetin