Output to Excel worksheet

J

Jeannette S.

Is it possible to use a macro to output the results of a query to a specific
named worksheet of an Excel workbook? If so, what is the correct syntax to
use?

Thank you in advance.
 
J

John Nurick

Hi Jeannette,

Try using
XXX!
as the Range argument of the TransferSpreadsheet action, where XXX is
the name of the worksheet.
 
Top