Hi There,
I have a piece of LS which is generating a 213 OLE Automation error. The code exports the contents of fields to a spreadsheet. It does this by creating a variant array and adding the values to the array and then pumping that data into the spreadsheet row by row (one row per document).
One of the documents has a field where the text is just over 1000 chars. This seems to be causeing the OLE error, here’s the line where the error occurs. btw lngVeCount = 2 iNumColumns = 34.
excelSheet.Range(excelSheet.Cells(lngVeCount, 1), excelSheet.Cells(lngVeCount, iNumColumns)).value = arrCellValues
Any idea’s what is causing this to happen? I’ve checked the size limits on a cell, and 1000 chars is well in limits, certainly isn’t 64k either…
Thx.