How to perform the Filter action in excel using vb script?

[venkatbatchu]

I have some 10000 records in excel among this there are duplicated data availabale, i need to filter the data based on selected value,

Please help me in this regard

Thanks in Advance,
Venkat

---

Hi All,
With some R&d and by searching i have got up to some extent of the solution which is am able to set the filter action and now i want to select the particular value in the data

Please find the below one

Code:

set aa=Createobject("Excel.Application")
set b=aa.Workbooks.open("D:\subbu.xls")
set c=aa.worksheets("sheet2")
c.cells(1,5).autofilter
set aa=Nothing
msgbox "Done"

Thanks in advance,
Venkat