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