"Analyse With Excel" code - I want it!!

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

Guest

Hi

I want to allow users to click a button and copy data from a background
table into Excel. How can I find the code that would achieve this?

Any help gratefully received.

Simon Jolley
 
In the button's on click event:

DoCmd.OutputTo acOutputTable, "TableName", acFormatXLS,
"FilePathAndName.xls", -1
 
Back
Top