Try this 3 video techhelp.  without a doubt this is what your looking for.
Excel Automation

Hit me back if this don't do the trick.

V/r
Juan

Thanks Juan,

The RecordSource used in this awesome series uses the CutomerT or CustomerLFQ objects throughout.

I've been searching the library for a method to use a recordset of filtered data as the RecordSource, instead of a static Table or Query, but don't seem to have come across anything yet.

Sometimes a Table or Query has massive amounts of data in it, and takes ages to save a file. If the data was filtered, before saving to the Excel file, it would reduce the time taken to export and only export the information you wanted.

I've tried a few options, but can't seem to get it. I figure the RecordSource will be the name of my query or another Subroutine where the query data has been filtered.

I'm at a loss as to how to export filtered data from a query to Excel.

Juan,

I have set the RecordSource as the necessary SQL statement, and the output works as intended.

The file doesn't save to the nominated folder because the SQL is used as the filename - obviously, that doesn't work.

I'd like to set the output filename to the query name, rather than the SQL so that it can be saved to the nominated folder...I figure I am just missing a final step in the process.

https://599cd.com/blog/display-comment.asp?CommentID=31465

Here is a link to an old thread.  this may help in pointing you toward creating a temp table with just the info you need, yhis may speed things up some.

again let me know if you need more help.

V/r
Juan