Addin Not Installing

[zSplash]

I have tried many ways to add and install my addin, all unsuccessfully.
This is the code I'm using:

Addins.Add("C:\Folder1\PFiles\MyAddin.xla").Installed = True

I get an error Run-time error'1004': Unable to get the add property of the
Addin class. I have also unsuccessfully tried breaking the code into first
adding, then installing.

What the heck does that mean? Can someone get me past this?

TIA

 

[Jan Karel Pieterse]

Hi ZSplash,

I have tried many ways to add and install my addin, all unsuccessfully.
This is the code I'm using:

Addins.Add("C:\Folder1\PFiles\MyAddin.xla").Installed = True

I get an error Run-time error'1004': Unable to get the add property of the
Addin class. I have also unsuccessfully tried breaking the code into first
adding, then installing.

What the heck does that mean? Can someone get me past this?

Download my Name Manager from www.jkp-ads.com and study the setup file that
is included inside the zip file.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

 

[zSplash]

Thanks, Jan. Your Name Manager does not show me anything. I get the
message "No Names in Active Workbook".

Someone, please help me. MyAddin has the path indicated in my code,
but will not install. Is it okay to have the pathname included in the name
of the addin (as I did), or is there something else wrong with my code?
Help!

TIA

 

[Jan Karel Pieterse]

Hi ZSplash,

Your Name Manager does not show me anything.

You misunderstood.

In the Name Manager's ZIP file, there is a file called
"Setup NameManager.zip"

Open that file and study the code in it, it shows how to install an
addin.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com