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.
 

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

Export Listbox in excel 1
Simple Methods to Export Gmail to Text? 1
Exporting a form page as an excel spreadsheet 2
Best Ways to Convert OST to PDF? 3
How to Export a query to a new spreadsheet 4
List Boxes - Access 2003 0
Exporting to Excel from Switchboard (Switchboard Manager) 1
Export a form's records to an Excel spreadsheet 6

Back
Top