Analyze it With Excel via Code

M

Mick

Hi
I have a series of reports which can be exported to Excel using the
following code:
DoCmd.RunCommand acCmdOutputToExcel

Clicking on the "Analyze it With Excel" button, exports to Excel and formats
differently to the RunCommand function.

I sometimes need to export in the Analyze format without giving the user the
option to do this with the Analyze button.

Any thoughts on how I can mirror the "Analyze it With Excel" through code
would be appreciated.

Thanks
 

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

Analyze with Excel In Access 2007 Sp2, Office 2007 0
Column order when using 'Analyze it with Excel' 0
Export to Excel over context menu error: cannot diplay the webpage 0
Analyze with Excel 2
Analyze It with MS Excel fails 0
Access report export to Excel 1
Truncated fields when Report analyzed in Excel 3
How to automate the "Analyze report with Excel" function with VBA 0

Top