Analyze it With Excel via Code

  • Thread starter Thread starter Mick
  • Start date Start date
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
 
Back
Top