Designating Spreadsheet Names in a Workbook Using Access VB

[Jim/Chris]

The name of the spreadsheet is the name of the query that
producedc it. It sounds like you are running the same
query twice. Copy the query with a new name and that name
will be the name of the second spreadsheet..

Jim

 

[Joe R.]

It's hard to explain, but what I am doing is filtering
based on a field in the query being from from combo box on
a form. Using this method I can save to a different file
each time, but what I would like to do is save the results
to the same file, but to a different tab or sheet. I can
accomplish this manually by renaming the query before
running the export function. And I suppose I can create a
temporary copy of of the query in the code and then delete
when the query is run. But rename the Sheet seems a more
efficient and cleaner way to do it.