Is there a limit on number of OLE objects that can be embedded in an excel sheet?
- by Varun Mahajan
I am adding OLE objects to an excel sheet through .net interop. However, after some calls, excel is not allowing adding more objects through code. Is there a limit? or am I doing something wrong.
Dim Htmlshape As Microsoft.Office.Interop.Excel.Shape
Htmlshape = xlWorkSheet.Shapes.AddOLEObject(, tmpFile, , True, strExplorerPath, 1, "")
Running this code gives an error after say 1000 calls. So, am I crossing some limit here?