10-08-2009, 10:53 AM
(This post was last modified: 10-08-2009, 11:50 AM by 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
Thanks in advance,
Venkat
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