Access 2007

I have a continuous form that displays filtered data from a table. I want to create a button that will export the filtered data to Excel. This would be to a NEW excel workbook. I have not found anything that will work.

Thanks,
Loren

Hi Loren,

Is the form based on a table or a query?

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

Hi,

Can you be more specific?

Is the form based on a query that filters the data? Is the filtering being done via controls on the form, pressing the filter buttons on the toolbar etc?
As for the excel file, are you just wanting to export the raw unformatted data. Can the Excel file be otherwise blank or does it require other stuff in it?

JonSmith

The form is filtering the data from the table via several unbound controls. The controls create a filter string and it is executed via a FILTER button.

I am looking to export the data into Excel just like it appears in the data sheet view.

If you created a Query with parameters based on the controls in your form then you could just export the query and use the inbuilt docmd.OutputTo Method.