Export As HTML Script

[BIProf]

I neet to create a script to export a BO report as html. I'm wondering where I can create the script and what needs to be included so that it runs when the report is submitted to BCA. Any info or samples would be geatly appreciated.

 

[ATP]

See thread393-88021 (VBA in BOB) for an example of some v4 script.

v5 converted this v4 script to VBA with no problems. This is run via the BCA to publish html reports to the intranet.

When submiting the report to the BCA use the "Run Macro" option.

I order to publish the html, the our BCA needed to be logged onto the domain (to have the relevant access to the LAN) and I needed to set "The Interactive User" option in "servconf" before the macro would run.

 

[GKar]

Hi BIProf,

Try to insert this part of code in you document after the refrech:
ActiveDocument.ExportSheetsAsHtml ("G:\spnt\index&quot

the full code should look like:
Private Sub Document_AfterRefresh()
ActiveDocument.ExportSheetsAsHtml ("G:\spnt\index&quot
End Sub

Hope it will help,

GKar