Command button for Analyze it with MS Office Excel?

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
 
J

Jeanette Cunningham

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template location changes from user to user 0
Export to Excel over context menu error: cannot diplay the webpage 0
Excell Otpions in office environment 0
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1
Request Form - Alert Team Member 0
Embed the same Excel multiple times 0
Setting a default zoom in Infopath 0
"Analyze it with Microsoft Excel" not working 1

Top