VBA macro schedule in xi r2

sdk development
1

Hi,

As part of BO migration, we have migrated universe and reports to Xi R2 and there are VBA Macro based reports which are being scheduled in 6.5 using BCA and is there any option available to schedule a VBA macro code. Options I am thinking o f:

  1. Have the VBA code in AFTERREFRESH() and schedule the report in CMC - But the issue is even if the end-user opens and refresh reports from his deski, the VBA would run.

  2. Create a VBS file and schedule as Object in CMC. Not working out properly.

  3. Write a Java script to do the same work

Which is easiest option …and let me know in case if anyother options available.

moorthy1974 (BOB member since 2008-07-18)

2

Macros do not work in Unix setups. If you are a Windows shop then the Macros should work.

Also, you can use alternate solutions whichever may be feasible for your environment.

a) Depending on your server setup, you can use XI Scheduler and use built in features of it.
b) You can use different programming (.NET/JSP/ Java Script/ VB Script), for this you have to make sure the settings are done correctly on your Program Job Servers.

BO_Chief :us: (BOB member since 2004-06-06)

3

Running reports with embeded VBA macros should not be a problem when running in DeskI, though there can be few changes depending upon the code written.
But running the same in Infoview is not the same as in BCA 6x and without drawbacks.
You can however get around it by invoking full client DeskI to fully utilize the VBA macro, using command line options and the same batch file scheduled or force run in Infoview. It will simulate the BCA functionality.

Is this your concern or just giving details?

.

haider :es: (BOB member since 2005-07-18)

4

One possible workaround for this is to add an IF…THEN statement like this:


IF Application.Visible=False THEN
    Call Macro_Code
END IF

This will only execute the macro code when being run on the server (InfoView or the Scheduler).

darcstorm :philippines: (BOB member since 2008-07-22)

5

Whenever we user application.visible or any application., the CMC or INFOVIEW scheduler does not pickup Before and After refresh macro and require re-start of deski job servers.

Any alternate ways to achieve the funcationlity.

moorthy1974 (BOB member since 2008-07-18)

6

What version of XI are you using?
Whate Service Pack and/or FixPack have you applied?

darcstorm :philippines: (BOB member since 2008-07-22)

7

We are using BO Xi R2 and SP4.

moorthy1974 (BOB member since 2008-07-18)

8

That’s strange, I seem to recall that I was able to get macros that uses application.visible property to work on SP4.
What does you macro do? Maybe posting your code may help.
Have you tried executing just the peice of code with the application.visible? Did that execute properly?

darcstorm :philippines: (BOB member since 2008-07-22)

9

Hi All,

I have the same issue. When I schedule my deski report from infoview which has entire VB macro embeded in it, macro is not executed.

We are using BO XIR2 SP 5. Even in SP5 we have this issue.

On client side report is working fine. Please suggest some solution.

Karthik LY (BOB member since 2009-02-25)

10

hi all…
i too have got the same problem…
macro not running in the infoview…

any solutions…

plz help me out to sort this issue…

Regards,
vadivel k

vadivelk (BOB member since 2009-07-28)