Return name of excel addin .xla
On 1 Jul, 14:36, "Peter T" <peter_t@discussions wrote:
An addin, whether installed or otherwise, is a workbook with its Addin
property set to True. To refer to "self" simply
ThisWorkbook.Name *or .Path or .Fullname
In passing, the relevant name for the Addins collection is .Title
Regards,
Peter T
"Tournifreak" wrote in message
...
Hi - I'm sure this is really easy to do, but I can't quite see it
somehow...
All I need to do is return the name of my Excel Addin, from within
that addin.
I'm sure it's something like:
Application.Addin.Current.Name
The reason I want to do it, is that the addin filename also contains
the version numebr, which I want to display on a form.
eg. MyAddin v002.xla
I want to display the v002 bit on a form. But I can't find a way to
get the addin name.
It's easy with a workbook name...
Thanks for any help!
Jon.
Brilliant - thanks Peter! I knew it would be something easy!
Best regards,
Jon.
|