Outputo Method

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

Guest

There appears to be something wrong with my syntax below,
but I cant seem to see what it is. I am trying to output
a query to an excel file through the OcClick event of a
command button.

Any ideas whats wrong?

DoCmd.OutputTo acOutputQuery, qryMarket, acFormatXLS
 
There appears to be something wrong with my syntax below,
but I cant seem to see what it is. I am trying to output
a query to an excel file through the OcClick event of a
command button.

Any ideas whats wrong?

DoCmd.OutputTo acOutputQuery, qryMarket, acFormatXLS
Click to expand...

Try

DoCmd.OutputTo acOutputQuery, "qryMarket", acFormatXLS
 
That did it. Thanks much
-----Original Message-----



Try

DoCmd.OutputTo acOutputQuery, "qryMarket", acFormatXLS


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.
Click to expand...
 
Back
Top