Command button for Analyze it with MS Office Excel?

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

Is there a way to create a command button to analyze the current data in
form view to Excel just like the button in the toolbar "Analyze it with
Microsoft Office Excel" function? so I can put it in my form for user to
click instead of toolbar. Thanks
 
Cam,
You can put a button on a form and code it like this:

DoCmd.RunCommand acCmdOutputToExcel

That will export data on the form to excel - no guarantees that it will work
well for all forms.

You can build a custom menu and put the Analyze it with Excel command on it.

Jeanette Cunningham
 
Cam,
I forgot to add the following:
The Analyze it with excel will not work in a runtime version of access. (not
tested in A2007 runtime)
I haven't tried DoCmd.RunCommand acCmdOutputToExcel in a runtime
version of access.

Jeanette Cunningham
 
Back
Top