getting the filter items
 

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

Hi Jay
I see that its just choosing the column but how can i get all the
items for the header?

Jay כתב:
Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

to be more precise,i need the excel column Criteria1
is it posible to loop this data with a macro?
thread כתב:
Hi Jay
I see that its just choosing the column but how can i get all the
items for the header?

Jay כתב:
Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

Hi Thread -

I just need to clarify so I can focus on the answer. I'll be unavailable
after posting this message, but will check back in about 3-4 hours.

Is this correct? You have an autofilter and one (or more) of the fields is
set to a specific criterion (resulting in hidden rows in your list).

Is this correct? You want to know what criteria are set for each column in
the fltered list.

--
Jay


"thread" wrote:

to be more precise,i need the excel column Criteria1
is it posible to loop this data with a macro?
thread כתב:
Hi Jay
I see that its just choosing the column but how can i get all the
items for the header?

Jay כתב:
Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

Hi Jay,
in a way yes,i want to use the filter criteria as a criteria to
access,
the other option that i have is to loop all the data in the column of
the excel file in order to spot all criteria
this is the solution i found so far,
if you have better solution for me it might faster the loop

Jay כתב:
Hi Thread -

I just need to clarify so I can focus on the answer. I'll be unavailable
after posting this message, but will check back in about 3-4 hours.

Is this correct? You have an autofilter and one (or more) of the fields is
set to a specific criterion (resulting in hidden rows in your list).

Is this correct? You want to know what criteria are set for each column in
the fltered list.

--
Jay


"thread" wrote:

to be more precise,i need the excel column Criteria1
is it posible to loop this data with a macro?
thread כתב:
Hi Jay
I see that its just choosing the column but how can i get all the
items for the header?

Jay כתב:
Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?

getting the filter items
 

Hi Thread -

Search Excel's VBA online help for the phrase "Filters Collection Object"
and go to that topic. There youll find ready-made VB code that collects all
of the criteria from an autofilter.

Good luck,
Jay


"thread" wrote:

Hi Jay,
in a way yes,i want to use the filter criteria as a criteria to
access,
the other option that i have is to loop all the data in the column of
the excel file in order to spot all criteria
this is the solution i found so far,
if you have better solution for me it might faster the loop

Jay כתב:
Hi Thread -

I just need to clarify so I can focus on the answer. I'll be unavailable
after posting this message, but will check back in about 3-4 hours.

Is this correct? You have an autofilter and one (or more) of the fields is
set to a specific criterion (resulting in hidden rows in your list).

Is this correct? You want to know what criteria are set for each column in
the fltered list.

--
Jay


"thread" wrote:

to be more precise,i need the excel column Criteria1
is it posible to loop this data with a macro?
thread כתב:
Hi Jay
I see that its just choosing the column but how can i get all the
items for the header?

Jay כתב:
Try this, but change "A1" to the address of the header cell in your column of
interest:

Range(Range("A1").offset(1,0),
Range("A1").End(xlDown)).SpecialCells(xlCellTypeVi sible).Select

--
Jay


"thread" wrote:

Hi all
I'm uploading excel to access and i would like to get the filter items
of one of the columns,is it possible?