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

0: vbext_rk_TypeLib
1: vbext_rk_Project


A ref to an app with a type library or to another VBProject

Regards,
Peter T

"Excel Monkey" wrote in message
...
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

So its Typelib for DLLs? What is Project for?

Thanks

EM

"Peter T" wrote:

0: vbext_rk_TypeLib
1: vbext_rk_Project


A ref to an app with a type library or to another VBProject

Regards,
Peter T

"Excel Monkey" wrote in message
...
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