Macro to 'Analyze in Excel'

  • Thread starter Thread starter RFJ
  • Start date Start date
R

RFJ

I've got a series of reports - lets call them "Report 1" and "Report 2" that
I'd like to automate in terms of producing excel spreadsheets of the same
report name.

I can do it manually and individually via the 'Analyze It' command in the
report preview window. I can get so far with my macro to open this report
preview window but is there a command I can then use to create then create
each spreadsheet - including the command to overwrite any previous version

TIA to the SKS's who help.

Rob
 
To automate this create a new macro

Select action "Output to"

Select object type "Report"
Select object name "Report 1 "etc
Select Output Format Microsoft excel
Output File Leave blank so that you can name the output
file and the location to which you want to save it
Auto Start select Yes

I hope that this is useful

Rgds Colin
 
Colin,

Excellent and thanks <G>

Do you know if I can automate getting round the message "xyz file already
exists. Do you want to replace it.".

I always do want to replace it.

Rob
 
Back
Top