I have a form in a subform, i have a command button
cmdExportExcel..

i want this cmdExportExcel export the filtered data in my subform to excel.is it possible in access 2003?
can anyone help me how can i write my vba codes for my cmdExportExcel.

thanks

revned

I want to introduce you one article. I read it and think that it will be helpful for you to solve the problem.
You can read it on
http://janewdaisy.wordpress.com/2011/02/25/fast-export-data-from-database-to-excel-and-generate-chart-without-automation/

[Edited by Daisy09 on 02-03-2011 at 03:17 AM GMT]

Access has a built in function for this. - DoCmd.OutputTo
You can use this function to output most objects from Access, including Queries, to most formats used in the main Microsoft Office products - i.e. Word and Excel.
So, if your subform is based on data from a Query then all you need to type in your vba code is:-

DoCmd.OutputTo acOutputQuery, "Query1", acFormatXLS, "C:\tmp.xls", False

If you highlight the OutputTo and hit F1 then Help will give you more detail.




____________________________
multi-tasking - the ability to hang more than one app. at the same time.