View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tournifreak Tournifreak is offline
external usenet poster
 
Posts: 6
Default 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.