Return name of excel addin .xla

[Tournifreak]

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.

 

[Nayab]

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.

Sth of the sort:::: Application.AddIns(1).FullName

 

[Tournifreak]

Sth of the sort::::  Application.AddIns(1).FullName

No, sorry that won't work.
Different installs of Excel might have any number of addins installed.
This code just picks out #1. I have 15 running for example. I need to
pick out the one which I'm calling from.

Jon.

 

[Peter T]

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]

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

Brilliant - thanks Peter! I knew it would be something easy!
Best regards,

Jon.