Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel 97
Message
De
09/04/2003 10:21:50
 
 
À
09/04/2003 09:38:54
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:
00775472
Vues:
17
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform