How do I get DrawingObjects collection?

Apr 11, 2012 at 5: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 

 

Coordinator
Apr 11, 2012 at 7: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