Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel worksheets in VFP6
Message
 
À
11/01/2000 09:32:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Divers
Thread ID:
00316031
Message ID:
00316215
Vues:
19
>Hello Bruce, John, and all others involved in this thread,
>
>I just tested the following lines in VFP6.0:
>excelsheet = getObject("c:\windows\desktop\a.xls")
>excelsheet.application.visible = .t.
>
>Assuming a file a.xls already exists on my desktop, it gets the object, and makes it visible to me. From what I'm understanding in this thread, it was said that this cannot be done in VFP 6.0. Is there perhaps a different problem, or am I misunderstanding the thread? I must, however, agree that whenever possible, the createObject() is better anyways. I just wanted to voice some opposition to the notion that you CAN'T use getObject for excel in VFP 6.0

I know mine would not stay visible in runtime with Getobject in vfp6, the exact same code that worked fine in vfp5, all vars made Public to be absolutely certain. Note that you must test these things in a runtime EXE situation, the Command Window is no good because it may give different results. Also, I was using Getobject to create a new XLS file, so that could alter things, too, I guess...but Getobject definitely does not work with Excel97/vfp6(SP3) when creating a new file, that much I'm quite sure of, I spent quite a while testing it.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform