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").Instal led = 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

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").Instal led = 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

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" wrote in message
...
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").Instal led = 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

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