Anyone know how to reference a vb project in vba

Hello All,

I am trying to learn how to reference the personal.xlsb and I don't see a way. I was thinking there were be some reference close to

Please Login or Register  to view this content.

Thanks
M

Norie,

Thanks for the response

I will try that. Not sure if it will work for my application, but I'll let you know!

Norie,

No luck. This creates a type error. My code is used to export all the modules from the personal.xlsb, but I am not sure how to reference it specifically.

The full line of code is

Please Login or Register  to view this content.

Norie,

Thanks! I don't think I have a good understanding of the container set up in vba. That worked perfect. I figured I would have to say .vbproject first.

As usual you were a big help.

Best,
M