Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to sort by asc in Excel ?
Message
De
21/05/2012 05:26:01
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Titre:
How to sort by asc in Excel ?
Versions des environnements
Environment:
VB 9.0
OS:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01543897
Message ID:
01543897
Vues:
62
Hi all,
I use vb.net and generate the excel. Import Microsoft Excel9.0 Object Library.
I already go to excel marco to sort the data,and copy this code. After i go to vb.net paste it but error.
Code in the below,error is xlAscending,xlGuess, xlTopToBottom no declared ...
Anyone can give some idea with me, Thank you ...


XL.Selection.Sort(Key1:=Sheet.Range("A" + startPoint), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom)



Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform