Export to Excel and/or HTML

[system]

Hello,

I currently use Business Objects 5.1.6.
I am looking for some advice or a piece of code that can take a multi tab report done with Business Objects and export it to different tabs in an excel file. Another option is to export it to HTML format.
The goal is to publish the report in a web site.

Many thanks for your help.
Gilad

---

gweinbach (BOB member since 2004-06-25)

[system]

Hi, welcome to BOB.

Try this for starters.

Export Report Tabs to MS Excel

The following code will process a document and export each individual report tab to MS Excel. It is currently done in the “AfterRefresh” event but could be called as a subroutine instead. Original Author: Unknown Original Author Comments: Private Sub Document_AfterRefresh() On Error GoTo error_handler Dim Doc As Document Dim Rep As Report Dim i As Integer Dim ExcelDoc As String 'Stores the name of the Excel document to copy all report tabs to Dim Path As String 'Stores the path in while t…

That’s a link to BOB’s Downloads, where we have some handy code samples and stuff.

---

Dave Rathbun (BOB member since 2002-06-06)