Oracle BI ...

[mark]

So today, I was asked to load the Oracle BI administration tool.

Along the way, it ran OracleBIOffice.exe , and now Excel has an additional
menu item on it, Oracle BI.

Although this may at some point prove useful, Oracle hasn't been gracious
enough to provide an easy way to turn it off when you don't want it. It's
not in the Tools-Add-Ins list, and I haven't found it in the StartUp or
AddIns folders in Program Files.

Can anyone tell me how to turn it off? I don't like it when people go
messing with Excel without asking nice first.

 

[Tony Zappal]

Hi,

Right click on your toolbars, select customise.
Then select the toolbars tab, select the toolbar and then select Delete.
Or you could just untick it.

Hoep that helps,
Cheers.
Tony Z.

 

[Tony Zappal]

Actually,
i just re-read your post.
Still rick-click on the toolbars, select customise.
Then in the Commands tab, you should be able to scroll down the categories
window, till you find the menu it is in, or the new menu itself.
The select the modify selection button to remove the item or menu.
BTW. what version of Oracle BI did you install?

Hope that helps.
Cheers,
Tony.

 

[mark]

BTW. what version of Oracle BI did you install?

Release 10.1.2.4.0 Build 080728.1900

Right, I can turn off the toolbar that way, and will go look about turning
off the menu...

but it's buried in the pc somewhere... you can watch it flash by creating
the menu as you open Excel.

Thanks.

 

[mark]

Then in the Commands tab, you should be able to scroll down the categories

window, till you find the menu it is in, or the new menu itself.
Then select the modify selection button to remove the item or menu.

doing that allows me to remove the changes to the File Menu, but they are
there again when I restart Excel.

 

[mark]

It's in the Control Panel - Add/Remove Programs.

So, it should be able to be removed from there.

Still wish I could just switch it on and off when desired, as opposed to
install/uninstall from Add/Remove

oh well.

by the way, I've noticed that other code modules are not properly closing
when files are closed, now that I've loaded Oracle BI, too. The file is
closed in the application window, but the code modules are still visible in
the VBE.

not good.

 

[Simon Murphy]

Mark
It sounds like a COM add-in. If you customise your toolbars and drag the
button for COM add-ins from inside 'tools' section to your toolbar you
can click it to get a list of COM add-ins installed (for the current user).

If its not in there then it may have been installed for all users in
which case I don't think there is a UI way to turn it on and off. You
could delete its settings, or maybe change its load behaviour from the
HKLM registry hive.

Poorly written COM add-ins will give you the VBAIDE project explorer
update fail you are seeing.

Cheers
Simon
Excel development website: www.codematic.net