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

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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,507
Messages
6,114,029
Members
448,543
Latest member
MartinLarkin

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