How to sort by asc in Excel ? - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

How to sort by asc in Excel ?

Message

From

21/05/2012 05:26:01

Alex Lam
Hong Kong

To

All

General information

Forum:

ASP.NET

Category:

Coding, syntax and commands

Title:

How to sort by asc in Excel ?

Environment versions

Environment:

VB 9.0

OS:

Windows XP

Database:

Visual FoxPro

Application:

Desktop

Miscellaneous

Thread ID:

01543897

Message ID:

01543897

Views:

61

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)

Click here to load this message in the networking platform