How do you Output to ... to a workbook tab

[jeep2001]

I have 4 queries that I output to Excel sheets, my question is how can I get each Output To into a separate workbook so all the queries can reside in 1 file.
This is my statement from access....

Dim strFileName As String

strFileName = "G:\Derek\BreachedByDay\BreachedAlerts" & ".xls"
DoCmd.OutputTo acOutputQuery, "qryGrossAlert", acFormatXLS, strFileName, True

 

[kjv1611]

First thing: Do you mean you want the queries to all go to separate Worksheets in the same Workbook?

 

[kjv1611]

If so, I know I've seen multiple threads already answered on this same subject in the past. I'd try doing a search on something like:
Multiple sheets same workbook

Or something like that, maybe try a few variations.