Here is my code:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, "C:
\Databases\RMA Database Redesign\ParetoTemplate2.xls"

Access says that I need to assign a file path or name.

Both the path and file name are correct.

Any ideas? I read the help and can't see what's wrong with my syntax.

Also, I tried to assign the path to a string variable and inserted it
into the argument for the TransferSpreadsheet. It didn't work either.
This seems easy but I can't crack it.

Thanks in advance.

Nevermind. I solved the problem. I didn't have a query named before
the file name argument. Sorry.

BUT, I have a another problem now. The export appears to happen but
when I open the excel file, nothing has been added to it.

Any suggestions?

Thanks.