Switchboard: Publish to Excel

[Kevin Sprinkel]

I would like to add a switchboard button allowing the user
to place the contents of a table into an Excel
spreadsheet, duplicating the Tools, Office Links, Analyze
it with Excel command.

Can anyone tell me what code to attach to the button?

 

[Howard Brody]

DoCmd.TransferSpreadsheet

Check the Help files for the syntax and detail.

Hope this helps!

Howard Brody