Enable Macros in deski

building reports desktopintelligence
1

Hi All,

I am using BO XIR2.I have a report with macros embed in it.Deski is displaying error VB is not available,so macros cannot be run.

Please show me a work around to enable this option.

Thanks in advance.

Thanks & Regards,
Mohammed Pasha.

mdpasha (BOB member since 2008-04-08)

2

hi pasha

open your deski report.
press alt f11
view-> project explorer
type the VB code and save that with the report meaningful name.

next time when you refresh , your macros is enabled.

judia

judia (BOB member since 2008-06-24)

3

Hi Judia,

Thanks for your prompt response.

I think this is related to BO Administrator.Alt F11 won’t work for this becouse Visual Basic for Application itself is not available so it won’t open the Visual basic editor.

Thanks
Mohammed Pasha.

mdpasha (BOB member since 2008-04-08)

4

hi pasha,

No, This is not an adminstrator work.
you have to open deski report.
click tools-> macros->visual basic editor
you can write macros by clicking view-> project explorer.
and save the document.

thank you
judia

judia (BOB member since 2008-06-24)

5

Hello,

I have same problem, when i open desktop (XIr2 sp4), it says "Visual basic for application is not instaled.

How are you solve this problem?

Thank you.

cgarcesg :es: (BOB member since 2005-11-14)

6

if you are on windows, have you tried first to execute your macro launching deski and running it on the server itself ? What is the result ?

another interesting posts regarding scheduled macros issues

bernard timbal :fr: (BOB member since 2003-05-26)

7

Hi there,

What sort of installation did you do ? Have you expressly uncheck VBA on the BO install ?

cheers

kenny :fr: (BOB member since 2007-01-02)

8

Hello,

I had installed a Desktop with Server instalation and the macros in desktop run perfectly.
An other day I installed de Designer with Server instalation and the macros in desktop don’t run.

Yesterday, I uninstall all BO and I instaled again and now all run perfectly.

cgarcesg :es: (BOB member since 2005-11-14)

9

ok so that comes from installation… but sorry I can’t be more accurate cause I don’t have an installation CD with me now.

cheers

kenny :fr: (BOB member since 2007-01-02)