Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation
Message
 
À
20/01/2004 22:10:59
Joel Hokanson
Services Integration Group
Bellaire, Texas, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00868829
Message ID:
00869022
Vues:
10
>oExcel = CREATEOBJECT('Excel.Application') will create an Excel object, but how to I find out the possible command to use with that object.
>
>I have seen a few, but I how do I find a list of all or some type of documentation.
>
>For example
>oExcel.Workbooks.Add
>oExcel.ActiveSheet.RANGE('A1').SELECT
>oExcel.ActiveSheet.Paste()
>oExcel.visible = .T.
>
>How do I insert a new top row into an existing XLS and populate one cell of that new row?

In addition to Jos's advice - a lot of us (and the articles will probably bare this out) use the macro record feature and the paste code from the macro editor into our apps and edit to work with VFP.
Imagination is more important than knowledge
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform