This project has moved and is read-only. For the latest updates, please go here.

How do I get DrawingObjects collection?

Apr 11, 2012 at 6:44 PM

  Dim obj As Object,ws as worksheet
'Error 155 Expression is of type 'LateBindingApi.Core.COMObject', which is not a collection type. 
        For Each obj In ws.DrawingObjects

  should I use

For Each obj In CType(ws, Object).DrawingObjects 

 

Apr 11, 2012 at 8:30 PM

same problem as before.

DrawingObjects is defined as anonym COM Proxy. currently is COMObject in NetOffice.
the next release do that better and its defined as Object.

*Sebastian