Exporting a table to Excel via a Command Button

[akki007]

I have a form that simply updates one table. I would like a command button that when clicked, exports all collumns from that table to Excel and opens up Excel.

Basically, the same procedure as File > Export...

Thanks

 

[PHV]

Have a look at the DoCmd.TransferSpreadsheet method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[akki007]

Thanks, I figured it out actually. I created a Macro and ran that via the button.