How can I get data from BO using VBA?

[system]

@Jimao

Hello Dwayne and Gary,

Thanks, the code Dwayne gave to me is working very well. But I would like to ask you a further question. Can I choose the universe name and the specific fields by using SQL language in the code instead of the report I have already created for?

What I did so far is I work on a project which collects data from different databases to create reports in Excel. I need the data from one database which I only get access by BO. so I try to get the current data automatically from the universe in BO instead of the manual data entry before.

thank you both for your useful help again!

Jimao

Is it possible? Yes, you can build a universe-based data provider on the fly. Look at the code here for some ideas. Then again, building it from Excel via VBA or natively in BusObj yields the same result, so I would think using native BusObj makes more sense. You could enhance my example by automating the logon, automating the BusObj refresh, and hiding that whole process so the user never sees anything.

All of this begs a much larger question. If this is going to be an ongoing type of reporting (data from different sources), it seems worth “doing it right” and creating an appropriate data warehouse, whether or not BusObj is your reporting tool. Just my two cents …

---

Dwayne Hoffpauir (BOB member since 2002-09-19)