Designating Spreadsheet Names in a Workbook Using Access VB

  • Thread starter Thread starter Jim/Chris
  • Start date Start date
J

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
 
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.
 
Back
Top