Button to Export List Box Contents to Excel

  • Thread starter Thread starter RockNRoll
  • Start date Start date
R

RockNRoll

Greetings,

Does anybody know of a way I can have a button next to my multiple column
listbox in my Access form to export its contents to an Excel workbook?
Thanks for your help.

-Dave
 
Look to see what the rowsource is of the listbox. It's either a table or query.
Use the Transferspreadsheet method to export the rowsource to Excel. You can
find Transferspreadsheet in the Help file.
 
Back
Top