Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to view an Excel worksheet?
Message
De
04/09/1997 12:27:24
 
 
À
04/09/1997 03:44:55
Information générale
Forum:
Visual FoxPro
Catégorie:
Fonctions Windows API
Divers
Thread ID:
00048405
Message ID:
00048530
Vues:
24
>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform