Excel Graph OLE LS Integration Problem

HCL Domino Domino Forum
1

Hi,

I have an agent that generate graph from excel OLE function. It works fine on domino R5 server. The problem start, when we migrate and upgrade the server to R6. The code below in [bold] are causing the code to stop executing.

Sub Generate_Graph()

.

.

.

With .Axes(1)

[<b>].MaximumScale = varDateMax

.MajorUnit = intXMajorUnit

.MajorUnitScale = intXMajorUnitScale

.MinorUnit = intXMajorUnit

.MinorUnitScale = intXMajorUnitScale[</b>]

End With

.

.

End Sub

The error generate is []ErrOLEException (213)[]. I have search many site, but couldn’t get any documentation on this exception error.

Please help asap, as it’s causing problem on our production server.

Thank You

Ronnie Tan

2

Subject: Excel Graph OLE LS Integration Problem

Insufficient information to answer. Some questions:

Are you using the stuff after the = signs as you posted or do these variables have values? If you just have ‘varDateMax’ and it isn’t set to some value, the code will fail.

Have you checked the MS site for the error code? They own the OLE functions so they’re the experts on how they fail.

Do you have any debug information?

Are these server agents? If not, migrating to a new server shouldn’t make a difference since the code is run on the user’s workstation.

If they are server agents, did you install Excel on the server?

HTH

Doug