Output Filtered Form to Excel (1 Viewer)

[hoschi]

I want to get a Output to a Excel Sheet from a filtered Form!

I want the user to enter the filter criterias, to see the filtered records and then by pressing a button to get a output to excel!

please help

thanx
hoschi

 

[hoschi]

I got it...

I made it with an SQL Statement and then I used following code for the output to Excel:

DoCmd.OutputTo acOutputQuery, "myQuery", "MicrosoftExcel(*.xls)", "C:\temp\output.xls", True, ""


hoschi