Hi,
I have a csv file that has huge data and i have to sort the data by Column A and then by Column B and then by C and then by D and by E.
using sort on each colum individually is not serving the purpose.
i could achinve till three columns by searing on the web regarding this. But the moment i add forth column it errors out.
Below is the function. i am also attaching the file to demonstrate the way this function sorts.
--------------------------------------
---------------------------
(copy it to text file and rename to filename.vbs and run)
if run the same function with another column for sorting it errors : Sort method for range class falied. here is the modified function:
----------------------------
--------------------------
has anyone worked with excel object extensively.. has anybody tried this... please try and help ....
Please..
Thanks in advance,
~neethu
Bookmarks