Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 97
Message
De
09/04/2003 11:48:12
 
 
À
09/04/2003 11:05:36
Jim Rieck
Quicken Loans/Rock Financial/Title Sourc
Livonia, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Divers
Thread ID:
00775180
Message ID:
00775549
Vues:
13
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform