Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel 97
Message
From
09/04/2003 11:48:12
 
 
To
09/04/2003 11:05:36
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:
00775549
Views:
11
I'd have to do some digging. There are others here who probably have this at their fingertips. But, I'm not sure it really matters. If you're not installing to a WinXP machine, then you need to install the dlls that came with the development environment (presumably VFP in this case), rather than the ones that came with WinXP.

Getting the info by using the Win api requires using a structure. There is probably a way to do it with scripting, but I haven't done much with scripting.

Alan

>Is there a way to get the version of a dll?
>
>Jim
>
>>Check out Q320108
>>
>>Alan
>>
>>>OK when I run the code below I get an Incompatable RPC Stub error. What does that mean?
>>>
>>>Jim
>>>
>>>>
oXl = CreateObject('Excel.Application')
>>>>? oXl.Version
>>>>If I remember correctly, Exel97 was 8.0
>>>>
>>>>But I have to agree with Cetin. There is no reason for the code you showed not to work. There must be something else going on.
>>>>
>>>>Alan
>>>>
>>>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform