| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setup project for Excel addin, won't register addin | Excel Programming | |||
| Removing an Addin from the Tools Addin list. | Excel Programming | |||
| Unshimmed Automation Addin and Shimmed COM Addin in same App Domai | Excel Programming | |||
| Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
| Excel COM Addin | Excel Programming | |||
Hybrid Mode
