Export Filtered Table to Excel

[pcolvin]

How do you export a table that has been filtered to excel? Everytime I attempt this, the entire table is exported rather than just the records that remain after the filter has been applied?

 

[PHV]

Why not simply export a query ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[pcolvin]

It would be great if I could just export it as a query, but this table is designed for the purpose of filtering by the user. Each user filters the table (which is not editable) to show only the records they need. There are limitless possibilites when it comes to filtering the table, therefore a query is impossible. It then needs to be export to excel so it can be uploaded into out mapping program or other programs. Because the user determines what records are needed, a query itself won't work.

For example:

User A wants to see only records from states in New England that are assigned to his/her boss.

User B wants to see only records from fiscal year 2009 that have no follow-up conducted.

User C wants to see only records that have been closed.

 

[SkipVought]

Hi,

PULL the data in from Excel using MS Query.

Depending on the complexity of the criteria, it might be able to be done with Data Range Parameters. You may have to do some simple VBA coding for more complex criteria.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}