Exporting multiple reports from BO to Excel.

[aarondewberry]

Hi all. I use this bit of code to export my data straight from Business Objects into an excel spreadsheet. This is fine when I have only one report in my BO doc.
How do I export to my excel spreadsheet if I have, say, three reports in one document, so that it appears in my excel spreadsheet under three seperate tabs?
Is this possible?

Dim Doc As Document
Dim Rep As Report
Set Doc = Application.Documents.Item(1)
Set Rep = Doc.Reports.Item(1)
Rep.ExportAsText ("file string.." + ".xls")

Many Thanks

 

[dbomrrsm]

view it in Webi and save from there - it saves each tab to a different excel sheet.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[aarondewberry]

Thanks for the quick response.

Excuse my ignorance but I am quite new to Business Objects. How do view it in Webi, am not familiar with the term.

Thanks

 

[dbomrrsm]

If you have the web based version of BO then it is Webi - from full client you can publish to corporate documents File..Publish To

Then when you view it through IE you can save to PC in excel and it saves as I said earlier.

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[aarondewberry]

Excellent. Thanks very much