microsoft+access+courses+in+london - Exporting to Excel

Hi Edwin,

It is possible to automate the export of a form to Excel by clicking on a button.

1. Create a macro object and set the Action column to "OutputTo"
2. In the Action Arguments, select the following...

Output File = Table
Object Name = "choose name of table"
OutputFormat = "choose Microsoft Excel version"
Outputfile = "leave blank to be prompted or specify the file path of the output excel your require"
AutoStart = "Yes if you want the Excel program to launch, No if you wish to lauch Excel yourself"

Save the macro

3. Create a form based on the table and add to the form a command button. Assign to the command button the above macro

Regrds