First, all you need is the Business Objects library. Designer and ctl are not needed.
Second, if your goal is to get the information to Excel, then use Excel. No need to complicate things with stand-alone VB. Set the same reference to the Business Objects library in Excel, and off you go!
Third, there is already a utility located here that does essentially the same thing that you are asking. It is a Business Objects document, but the results could be “saved as Excel” if you like. In any case, the code there may serve as an outline for you.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)