Exporting report to Excel automatically

[robertlevine]

I currently create a report in Access97 that gets printed when executed with the following code:

DoCmd.OpenReport "Risk Break Report", acNormal, "", "portfolio like 'US8*'"

What I'd like the report to do as well, is export to an Excel Spreadsheet (similar to what I can do manually with "Analyze in Excel")

Is this possible? If so, how?

Thanks guys!

 

[jbg]

DoCmd.OutputTo acReport, YourReportsName ,"MicrosoftExcel(*.xls)", "", False, ""