Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems using Excel Sort Method
Message
De
19/07/2000 15:49:40
Jared Anderson
Marketing Support Solutions, Inc.
Forest, Virginie, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
00394423
Message ID:
00394516
Vues:
16
The syntax for Excel(97)'s Sort Method is:

Sort([Key1],[Order1],[Type],[Key2],[Order2],[Key3],[Order3],[Header],[OrderCustom],[Matchcase],[Orientation],[SortMethod])

It was the "Type" parameter I was leaving out, that's why there is just the 'double-comma' there. I normally don't have any trouble with 'omitting' parameters this way in FoxPro, and when working in Excel directly with VB/VBA, you can omit them that way too.

BUT, thank you for drawing my attention to it anyway, BECAUSE: it happened to make me think that I had not, in this case, tried passing "" instead of not passing anything at all. I guess there is some sort of issue in the Automation "translation" between FoxPro and Excel when it comes to empty parameters?

So, even though it should have worked, it didn't. Adding in "" took care of it :)

Thank you!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform