Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Automation - Sort
Message
 
À
01/11/2001 14:37:54
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00576343
Message ID:
00576368
Vues:
23
Try:
with objExcel
.Selection.Sort(.Activesheet.Range("B1"), .Activesheet.Range("C1"))
endwith

>I'm trying to sort all the data in an Excel spreadsheet from a VFP 6 program with this command:
>
>.CurrentRegion.Sort Key1:=Range("B1"),Key2:=Range("C1")
>
>My other Excel commands are working, but this one is giving me a syntax error and my guessing of variations haven't worked.
>
>Any clues?
>
>Also, do you know of any good documentation on command syntax for working with Excel from VFP, other than "Microsoft Office Automation with Visual FoxPro"?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform