Output to Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Jeannette,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Output to Excel 2
Excel VBA 0
Excel import 1
Export data to Excel file... 4
Output to macro action 1
Use transferspreadsheet in macro, randomly receive error 2950 8
Export Query using Access 2007 to Excel 2003 Users 2

Back
Top