View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
zSplash zSplash is offline
external usenet poster
 
Posts: 28
Default Addin Not Installing

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