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

How Run query then Automatically Analyize in Excel via Macro 1
Analyze It with MS Office Excel Vs. DoCmd.TransferSpreadsheet 1
Analyze it with MS Excel to specific folder 3
analyze data with excel feature in office 2007? 2
Analyze with excel 1
Analyze It with MS Office Excel 1
Excel Analyzing Access Reports in Excel 2
Access Automatically Send a notification email once a record is added 0

Top