BusinessObjects Board

Linking BO from Exel

sdk development
#1

Folks,

I’m looking for a sample script or VB source code that allow me to link BO from Exel. The user needs to click on a single button in Exel and the backend engine will actually perform the following actions which are transparently to the user:-

START

  1. Lauch BO Application
  2. Bypass login
  3. Run a report in BO
  4. Save the results to temp excel workbook
  5. Exit BO Application
  6. Open temp excel workbook in Exel
  7. Copy by extract the necessary data
  8. Paste the data on onother worksheet
    END

Any help would be greatly appreciate.

Thanks in advance.

btquah (BOB member since 2007-07-02)

#2

Welcome to B:bob:B!

Take a look at the white paper located here …
Using BusObj Reporter as a data source for Excel / Access

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

#3

Hi Dwayne Hoffpauir

Thanks for your help. But, this is NOT the one that i am seeking for. I would like to have everything done in Exel. Exel will be the main platform for the development. And link to BO to retrive the data fr Exel. That’s it.

Thanks & awaiting for your advise :slight_smile:

btquah (BOB member since 2007-07-02)

#4

It was just a suggestion. The document was written for v5, which did not have a native “save as Excel” functionality. The example code to launch BusObj, retrieve, open, refresh would still work. Instead of saving as text, save as Excel. The rest of your requirement (move data from the temp Excel file to another Excel file) is outside of Business Objects at that point.

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

#5

IMHO, a waste of the capabilities of Business Objects… :?

Mak 1 :uk: (BOB member since 2005-01-06)

#6

guys,

Million of thanks for the help! anyway, i need to firgure another way out to resolve my problems:)

btquah (BOB member since 2007-07-02)