You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by ND on Thu 4 Sep 2008 in response to Keeping the boss happy

how to sort columns

hi


Can someone tell me how to sort data in the excel spreadsheet using the
following code?


Print |Content-Type:application/vnd.ms-excel|


Print |<table border="1">
<tr><td width="80">Quarter</td><td>Sales</td></tr>|


While Not(ne Is Nothing)


Print|<tr>
<td>| + ne.ColumnValues(1) + |</td>
<td >| + ne.ColumnValues(2) + |</td>
</tr>|


Set ne = nv.GetNext( ne )
Wend


I WANT TO ADD CODE TO SORT BASED ON USER INPUT. Can someone help.


Thanks in advance.