Exporting a list box in Access

[Tript99]

Hello,
I was wondering if anyone knew if it was possible to export the contents of a listbox (in Access 97 form) to an excel spreadsheet. I've been trying to use this code but have been unsuccessful so far..

Private Sub cmdExport_Click()
DoCmd.OutputTo acOutputObject, "lstTest", acFormatXLS, , False
End Sub

Any help would be great!
Tript.

 

[jebry]

Hi Tript!

If the rowsource of the list box is a query you can use the output to command:

DoCmd.OutputTo acOutputQuery, lstTest.RowSource, acFormatXLS, , False

If it is an SQL statement, you may be able to create a querydef first and then use the output to command like it is above. Barring that, you should be able to recreate the rowsource programmatically and create a query that you can then export.

hth Jeff Bridgham
bridgham@purdue.edu