"Type" Property for a Reference Object in a VB Project

E

Excel Monkey

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
 
P

Peter T

0: vbext_rk_TypeLib
1: vbext_rk_Project


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

Regards,
Peter T
 
P

Peter T

So its Typelib for DLLs?

Not only dlls but just about anything other than a VBProject
What is Project for?
As I said, to another VBProject, eg an addin if you want to call its
functions directly.

In passing, if you ever want to do that best to rename the default
"VBAProject" to something unique.

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top