View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Excel Monkey[_2_] Excel Monkey[_2_] is offline
external usenet poster
 
Posts: 36
Default "Type" Property for a Reference Object in a VB Project

Can someone tell what the .Type Property means for a Reference object in a VB
Project? See example below. I get a Type of 0 for all my references.

Sub VBERefList()
Dim chkRef As Reference
Dim vbProj As VBProject

Set vbProj = ThisWorkbook.VBProject

For Each chkRef In vbProj.References
Debug.Print chkRef.Type
Next
End Sub

Thanks

EM