Business Objects and Excel and VBA

mrowe

Board Regular
Joined
Feb 17, 2002
Messages
232
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
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Bump!

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

Any ideas?

ta
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
Shouldn't you have a reference to BOApp somewhere there?

Perhaps something like this?
Code:
BOApp.Reports(1).ExportAsText (strPath & "\NSIRauditdataset.txt")
Or this?
Code:
Doc.Reports(1).ExportAsText (strPath & "\NSIRauditdataset.txt")
 
Upvote 0

Forum statistics

Threads
1,213,554
Messages
6,114,280
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top