Analyze it with Microsoft Office Excel

[gblack]

There is a feature in MS Access Reports which is found in the reporting design mode under Tools>>Office Links>>. It is called “Analyze it with Microsoft Office Excel”.

I want to programmatically use this feature. Does anyone know the syntax for doing this? I know that if it is in the menu bar, then I should be able to do the same thing programmatically…right?

Does anyone know what I am talking about? I ran a search on “Analyze it with Microsoft Office Excel” but nothing came up. I think I am the worlds worst searcher of things like this.

 

[gblack]

NM I found it

I made a macro that does what I wanted and converted it to VBA... This is what I got:

DoCmd.OutputTo acReport, "Report Name", "MicrosoftExcelBiff8(*.xls)", "", False, "", 0