Business Objects and Excel and VBA

[mrowe]

Hi Again

I need to create the code that will export a Business Objects report to a .pdf or .xls then email it to the client.

The code is done in BO script called "Report sript" but is similar to VBA.

I know this is a bit out of scope of the site, but if anyone has experience doing this it would be greatly appreciated.
Matt

[mrowe]

Sorry to bring this one back... any idea?

[asylum]

sorry to bump such an old post but i too would like to do this.....

Any ideas?

ta

[Tom Schreiner]

You are going to have to educate us a bit in order to recieve some help. Is this "Report sript" something that is available to VBA via COM? Does it need to be translated into VBA?

[asylum]

Ok sorry, this is the code: - problem occurs in the penultimate line (I have discoverd that i am running BO 5.1.8 which cannot export to excel!, but should export to a text file which i can then open in excel)

any ideas why this will not work? - error is Runtine error 424 object required

thanks

Dim BOApp As busobj.Application
Dim Doc As busobj.Document
Dim DataProv As busobj.DataProvider

Set BOApp = New busobj.Application
BOApp.Visible = False

Call BOApp.LoginAs

Set Doc = BOApp.Documents.Open(strPath & "\NSIRauditdataset.rep")
Doc.Refresh
Document.Reports(1).ExportAsText (strPath & "\NSIRauditdataset.txt")
Doc.Save

[Norie]

Shouldn't you have a reference to BOApp somewhere there?

Perhaps something like this?

BOApp.Reports(1).ExportAsText (strPath & "\NSIRauditdataset.txt")

Or this?

Doc.Reports(1).ExportAsText (strPath & "\NSIRauditdataset.txt")

[asylum]

Thnak Norrie, the second line was just what i needed! ta