Saving an automated query as .xls

[UniqueTII]

I made a macro that runs a saved mainframe query ion Excel and I was just wondering if it's possible to write some code or a macro that will save the info returned as a certain filename in a certain folder. Any help would be appreciated.

The final goal is to run the query, save the spreadsheet, and then use TransferSpreadsheet to make a new table.