Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel application object model
Message
De
28/04/1999 23:19:51
 
 
À
28/04/1999 09:41:50
George Simon
GS Data Technologies, LLC
Cincinnati, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00212953
Message ID:
00213281
Vues:
27
>Hi eveyone,
>
>Where can I find information on Excel's application object model as an OLE automation server?
>
>TIA
>
>George

Hey George- in addition to what everyone else has told, you should know about the object browser available inside the VBA editor in Excel. In Excel, go to tools-> macros -> VBA editor. ONce in the editor, press F2 to get the object browser. You can type in the name of any object to get it's list of properties and methods.

If you aren't hip to the trick yet- the fastest way to get Excel (and Word) automation work done is to record a macro and then look at the code generated coded in the macro VBA file. After translating VBA's named parameter scheme to VFP positional parameters and translating the constants by looking up their values in the object browser, things are downhill from there.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform