Export Data to Excel

[Mehmet Ceylan]

How can I export the data to an excel file from a listbox on the form?

 

[Naresh Nichani MVP]

Hi:

If the data in List is from a table on based on a SQL statment use thhsi VBA
code on a button to do the excel export.

application.DoCmd.TransferSpreadsheet
acExport,acSpreadsheetTypeExcel3,"TableName","C:\My DOcuments\Test.xls"

Here TableName is the name of Table to export and is exported to Test.xls.

Regards,

Naresh Nichani
Microsoft Access MVP