Edwin has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Exporting to Excel
Is there a VBA Code that will allow me to Export a table into Excel byu clicking on a button (or Event), instead of going through the toobar and manually exporting it?
RE: 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
