paulnnosh
MIS
- Mar 25, 2004
- 32
Hi Guys,
I have a subform with a datasheet. I use the following line of code to output the data to an Excel spreadsheet.
DoCmd.OutputTo acOutputForm, "subProspects", acFormatXLS, "prospects.xls", True
This copies all data from the subform into Excel. What I would like to do is export only data data that is currently filtered (e.g Only those rows owned by a specific user). However when I filter the data and run the code it still picks up all the records. Is there anyway I can use the outputto method to do this?
Many Thanks
I have a subform with a datasheet. I use the following line of code to output the data to an Excel spreadsheet.
DoCmd.OutputTo acOutputForm, "subProspects", acFormatXLS, "prospects.xls", True
This copies all data from the subform into Excel. What I would like to do is export only data data that is currently filtered (e.g Only those rows owned by a specific user). However when I filter the data and run the code it still picks up all the records. Is there anyway I can use the outputto method to do this?
Many Thanks