Return name of excel addin .xla
 

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.

Return name of excel addin .xla
 

On Jul 1, 6:20*pm, Tournifreak wrote:
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

Return name of excel addin .xla
 

On 1 Jul, 14:29, Nayab wrote:
On Jul 1, 6:20*pm, Tournifreak wrote:



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

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.

Return name of excel addin .xla
 

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.

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.