Naming an Excel Spreadsheet from Access

[Joe R.]

Using code in Access I want to rename a Spreadsheet in an
Excel workbook.

I've tried the following code:

'where qryExcel is the name of the existing spreadsheet
Sheets("qryExcel").Name = "test"

and I get the error message below:

Runtime error 1004
Method 'Sheets' of object '_Global' failed

If anyone out there knows how to do this, I would
appreaciate some help.