Export 1 Query Using Criteria to Multiple Excel Worksheets

I believe the TableName parameter used in TransferSpreadsheet is used to specify the worksheet name.

You need to take the Territory number OUT of the filename, and rename qryDummy to something representing Territory# for each iteration through the loop.

I would consider making a copy of qryDummy to start with though. This can be deleted at the end of the process. Otherwise, if it is ever cancelled or interrupted then qryDummy may not be available next time (It may be there but with a Territory# for the name).

A (sort of) continuation of this question can be found at Export multiple queries to multiple sheets in excel.

Probably best continued in here on balance, but for a similar problem, please see the linked thread.

Heather,

From reading your latest post (in the other thread) in full I get the impression that you're asking for exactly what is in my post #2 in here.

I know the interface for this is not the most intuitive in the world (a parameter for specifying a worksheet name would not go amiss), but that's what we're stuck with I'm afraid.

If you explain what you find confusing I can hopefully rephrase it (My explanations are not always the easiest to understand I know - even though I do try to make them so).

You'll see this isn''t simply about the code. It also relies on items existing in your database before we start.