sort data by column A then by B .. so on

[vijaychandrika]

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.

--------------------------------------

Please Login or Register  to view this content.

---------------------------
(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:
----------------------------

Please Login or Register  to view this content.

--------------------------




has anyone worked with excel object extensively.. has anybody tried this... please try and help ....
Please..

Thanks in advance,
~neethu

[arthurbr]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here