VB addin excel can't see any workbook

[g***@conclusion.nl]

hello,

I'm building an excel addin. I have a button which activate an user
form. In the code of my form. In the background I want the workbook
name. But if I ask a count of all the workbooks the answer is 0.
msgbox Workbooks.Count

Can someone tell me how I can get the workbook name.

Gertjan

[Bob Butler]

Post by g***@conclusion.nl
hello,
I'm building an excel addin. I have a button which activate an user
form. In the code of my form. In the background I want the workbook
name. But if I ask a count of all the workbooks the answer is 0.
msgbox Workbooks.Count
Can someone tell me how I can get the workbook name.

You'd do better asking in an Excel VBA or addin group; this group is for
add-ins to the VB IDE, not so much for add-ins written in VB.