button to export table into excel

[monadel]

Hi,

I am a newbie here for exporting about exporting things into excel.
I have a form displaying information that user can add/update which is stored into a table.
What I want is a button on the form that user can export all info into excel that table only.

thank you

[zaidlig]

Add a button. At the event on_click add

DoCmd.TransferS preadsheet acExport, acSpreadsheetTy peExcel9, tablename, newfilename