Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel 97
Message
From
09/04/2003 11:53:46
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
09/04/2003 09:38:54
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Miscellaneous
Thread ID:
00775180
Message ID:
00775557
Views:
12
ox.Version
Cetin
>It's running on Windows NT. The user is an administrator and has full rights to the folder and can open the file manually.
>
>Is there a way to create the Excel object and determine that it's Excel 97?
>
>Jim
>
>>>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
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform