Missing Reference to Excel

[MichM3]

Dear,

I have a report in Business Objects which is altered by some VBA code. The code contains steps as Refresh the report, save it as Excel and add some pictures into the Excel WB.

When I execute this VBA on my local machine, it works fine.

Scheduling it on our Broadcast Agent server (BO Scheduler) fails however.
Why => because on our Server no Microsoft Office software is installed which means that VBA misses the Excel Reference library....and I need that one for my VBA!!

Installing MS Office is an issue as the company's policy is to avoid MS Office being installed on Servers.

Can our issue be solved?? Can we install some dll's that will allow us to run the VBA script with Excel Reference library?

 

[SkipVought]

If an Excel Application is not properly installed on a server, then it cannot run your Visual Basic for Applications.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

I have a report in Business Objects which is altered by some VBA code. The code contains steps as Refresh the report, save it as Excel and add some pictures into the Excel WB."

My bolding.

This is simply not possible if Excel is not available. One can hardly add picrture into a WorkBook if a WorkBook is not available. If it is not on the server, the server can not action it. The fact it is a server is, technically, not even relevant. VBA acts on local references.

"save it as Excel and add some pictures into the Excel WB."

Can your Business Objects code send those instructions to a machine that does have Excel (rather than trying to action on the server itself)?

Gerry

Och ammmmm, I think I need a shave.
- hirsute Scot, trying to decide

 

[MichM3]

ok thanks!

that's clear... we already thought it would be difficult. so we have to search another solution

 

[xlbo]

If you are using SQL Server, then you could avoid using BOBJ altogether and use SSRS which can export to excel and can be scheduled

Alternatively, you may be able to use .NET to automate

Alternatively again, simply query the data data directly into excel using VBA / ADO connection - schedule using windows scheduler....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question