I don’t think the domino OLE implementation for Excel recognizes the Calculated Fields.Add method for pivot tables because when I try to do this I get “Automation object member not found”. This was the case throughout all releases for R5 and is behaving the same way in R6.5.1. Is this a known issue?
Subject: RE: Excel Pivot Table - Calculated Field Does Not Work
There is no such thing as the “Domino OLE implementation for Excel”. There’s a generic OLE implementation whose behavior is defined by whatever other program you’re connecting to. There’s nothing special in the Notes/Domino code to deal specifically with Excel – all this is based on what methods Microsoft has exposed in their Excel OLE interface. Have you tried the same code in VB?
Subject: RE: Excel Pivot Table - Calculated Field Does Not Work
Yes, I’ve tried the same code in VB and it works fine. And in the Designer IDE the object browser lets you select and paste the method but the “Automation object member not found” error occurs at runtime.
Subject: RE: Excel Pivot Table - Calculated Field Does Not Work
Would this be a problem to pursue with Microsoft or Lotus? Since the method works in VB but not in LS can I assume the problem is on the Lotus side?
Subject: Excel Pivot Table - Calculated Field Does Not Work
Add () after calculatedFields - CalculatedFields().Add