Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to view an Excel worksheet?
Message
 
À
04/09/1997 12:27:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Fonctions Windows API
Divers
Thread ID:
00048405
Message ID:
00048573
Vues:
21
You could also just put an ExcelWorksheet OLEControl onto your form.

>>>What is the best way to view a spreadsheet? I'm currently using a "RUN" command followed by the file name but this displays the "Foxrun" command window (big black box).
>>>
>>>Is there another, more elegant way to do this?
>>>
>>>Thanks in advance
>>
>>Hello,
>>
>>Excel is an EXCELLENT OLE server (i have used it extensively).
>>Anything you do think of with Excel can be nicely requested from fox.
>>
>>Try this (should work with recent versions of Excel) :
>>
>>oExcel=getobject(getfile("xls"))
>>oExcel.windows(1).visible=.t.
>>oExcel.application.visible=.t.
>>
>>you can, of course do much more,
>>
>>François
>
>This looks like exactly what I need but I get an error message when I try it.
>
>The message is "OLE object does not have a windows property" so the second line crashes.
>
>Are you setting up a form with an OLE object on it? Is this object named oExcel? Is there a CommandButton with this code in the 'Click' event?
>
>Thanks in advance.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform