Return name of excel addin .xla

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.
 
N

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
 
T

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.
 
P

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top