Business Objects and ADO Recordsets

[LeanneGodney]

Hi there,

I am trying to retrieve information from Business Objects into an Excel spreadsheet, using VBA. I'm aware of (and am currently using) the export option. But ideally I'd like to use an ADODB Recordset, or something similar to grab the results of a report in Business Objects into a recordset and be able to use the "activecell.CopyFromRecordset" function within excel VBA.

So far I have come up with NOTHING. For those BO programmers out there - is this possible?

I don't want to export to a text file and then import that because this is slow and I have to feed each line into Excel. This is SLOW.

Does anyone have an suggestions?

Thanks,
Leanne

 

[hilfy]

Which version of BO and which type of report - Full Client/Desktop Intelligence, WebI, Crystal are you using?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.