sorting a excel sheet using vb

Expand Post »

I need a VB code to open an exisitng excel file and sort a column and store in diff excel sheet.eg i have a column data A,B,C,D,E.the code should sort all the A in the column and store in new excel sheet..as like all B,C,D,E should be stored in diff excel sheet....................

ANY WHO KNOWS pls HELP ME ...............

Similar Threads

Retriving data from excel sheet into an asp page in ASP
Exporting From Crystal reports to Excel sheet in ASP.NET
Open Excel Sheet in Vb.net in VB.NET
To Fetch EXCEL sheet values thro' ASP page. in Configuring Readymade Scripts
VBA - Excel - sheet,range lookup with variables in Visual Basic 4 / 5 / 6

laxman_project

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2007

Permalink

Oct 15th, 2007

Re: sorting a excel sheet using vb

Use the macro recording feature of Excel; you can find it yourself :-)

yello

Reputation Points: 13

Solved Threads: 4

Light Poster

Offline

30 posts
since Nov 2006

Permalink

Oct 16th, 2007

Re: sorting a excel sheet using vb

thanks yello but i have tried that before but sorting is perfect but when copying in to new excel the program is not recording for that .............so if u have code for whole project pls send me

laxman_project

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Oct 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: join in select statement

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: left join

DaniWeb Message

Cancel Changes

User Name
Password