Return name of excel addin .xla

  • Thread starter Thread starter Tournifreak
  • Start date Start date
T

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.
 
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.
Click to expand...

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

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.
 
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
 
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
Click to expand...

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

Jon.
 
Back
Top