Hi,
i export some data from a Notes database to an Excel sheet via OLE. This works fine!
Now, i want to generate an Excel chart with the data stored in the sheet. I use VisualBasic (VB) methods and properties inside my Lotus Script agent to do this. When i try to set the values (or the XValues for the axis) for the series i get a “Type Mismatch”. The error occurs in the following line:
…
.SeriesCollection(“Volumes”).Values = vxlsheet.Range(vxlsheet.Cells(iStartCountryData, 4), vxlsheet.Cells(iStartCountryData + iCountryDocCount - 1, 4))
If i use the same line with a “.Value” at the end i get no error and the chart will be generated. But in this case there is no link between the chart and the data of the sheet. To achieve this i must use the range object itself and not its values. When i use this piece of code directly in a Excel macro everything works fine, but not via OLE in Notes…
Any ideas what to do?
Regards,
Marc