[VB2005] [Resolved] Sort excel file

[Zoroxeus]

Hello
I am getting a "COMExecption unhandeld" at this line of code...

  oSheet.Range("A2", "G" & EndRows).Sort("A2", Excel.XlSortOrder.xlAscending, "B2", Excel.XlSortOrder.xlAscending)

EndRows is defined as the last row
oSheet as excel worksheet
Trying to ignore the first row (title) therefore the range is A2 => G....
And trying to sort on two columns, A and B....

What am i doing wrong ?

Thanks !

[zaza]

A quick look at the handy Excel Help for the Sort function would reveal that the Key parameters used to identify how to sort need to be either names or Range objects.

In your case, I suspect you do not have a range named "A2", so you will need to use osheet.range("A2").

Also, Excel will automatically recognise xlAscending. You don't need to use Excel.XlSortOrder.


zaza

[Zoroxeus]

Excellent thanks !
i had actually looked at MSDN .. so i used "range("a2") and it did not work... did not know i had to use "osheet" as well
thanks !