How to automate the "Analyze report with Excel" function with VBA

B

Balex

Hi

I have a report with subtotals which I wanted to export to Excel. The report
function "Analyse with MS Excel" under the "Office Links icon is ideal and
gives me just the Excel file I need.

Now I'd like to automate the report export to Excel completely through VBA
code. However, I did not succeed with the DoCmd.DoMenuItem, which SHOULD do
the job, because I can't find the 3 necessary parameters, the MenuBar
constant, the MenuName constant and the Command constant corresponding
respectively to the "Print Preview" toolbar, the "Office Links" "menu" under
that, and the "Analyze it with Microsoft Excel" submenu within that.

Can anyone hepl me here ?

Thanks
BAlex
 

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 to automate the "Analyze report with Excel" ? 0
Analyze with Excel In Access 2007 Sp2, Office 2007 0
Analyze with Excel 2
Analyze It with MS Excel fails 0
Export MS Access report to single html 1
Truncated fields when Report analyzed in Excel 3
Analyze it With Excel via Code 1
Report exported to Excel 0

Top