Export Listbox to Excel

[brsawvel]

Hello,

I have a multi-select listbox that, when records are selected, sends those records to a report.
I would like to create a second button in my form that sends the same data to an Excel Spreadsheet.
Is this possible?

Listbox name - lstHidden1
Listbox source - qry1

 

[ted.martin]

If the List Box was based on a table ratheer than entered in the value property, you then easily write a macro to export the list box to excel.

 

[brsawvel]

It is based on a query that draws from a table. My problem is that, being a newbie, I don't have the slightest idea how the macro should be written.

 

[GaryPanic]

do a search under code options for
qry to excel-
all of the code is prewritten for you and what libiaries your need