You are replying to:

1. • 
   • ND
   • Posted on Thu 4 Sep 2008

   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.

Your Comments