Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft+access+courses+in+london - Exporting to Excel
|
|
|
The UK's most regular Training information:
See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft+access+courses+in+london - Exporting to Excel
Resolved · Low Priority · Version Standard
Reply Tue 28 Nov 2006, 19:41Delegate Edwin said...
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?
For upcoming training course dates see: Pricing & availability
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
|