>All,
>
> I have a client with Excel 97 running on a machine. My VFP program opens a workbook, but when the code runs I get a workbooks does not evaluate to an object. The code(below) works with Excel 2000 and XP. What's wrong?
>
>
> oExcel = Createobject("Excel.application")
> oExcel.workbooks.open(".....")
>
Jim,
I believe it's not Excel97 problem. As far as I can remember in Excel97 (win9x,win2k) I was opening the workbooks same way. I've clients still using Excel97 on different platforms.
Sounds like the answer is hidden in ellipsis. Is it a fullpath to a file that user have necessary rights to open ?
And could user open it manually from Excel w/o any error ? (some linked objects for example were a cause to fail)
Cetin