Indeterminate behavior from DoCmd.TransferSpreadsheet in Access 2003?

Hello,

I am sending the output from 2 different queries to spreadsheets via DoCmd.TransferSpreadsheet.

When I set up one query, it quite nicely overlaid the data in the spreadshet on the Tab with the same name as the query. This was good.

When I set up the other query, it insists on creating a new tab every single time! This is Bad.

Why oh why will one query work the right way and the other work the wrong way (Kinda Urgent).

Creates new worksheet every time (BAD)

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryEligibleAppsForAGivenSchool", pathString + txtSSName.Value

Uses previously created Tab (GOOD)

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Eligible and Registered Student List", pathString + txtProvider.Value

Looks indeterminate to me.

M