Sounds like the path and/or filename is wrong. Load the addin some other way
(double click, drag into Excel etc). Select it in the VBE's project
explorer, in the Immediate window (ctrl-g)

?thisworkbook.fullname

Afraid I could make sense of the rest of your post.

Regards,
Peter T

"Mike H." wrote in message
...
I get this message so I just went to doing this when I load a file that I
wish to have the add-in loaded for:

Workbooks.Open Filename:="P:\Library\test\test.xla"

But now I get a run-time 1004 error: Method 'Open' of object 'Workbooks'
failed. I can't seem to get the addin to function exactly right. I am
using
XL 2003 version ,b tw! Anyone have suggestions. I get error messages
sometimes when I load the added using the addin "ToolsAddins". Ideas
what I
am doing wrong? Also, I wish the addin to load one any a dozen files is
loaded , but I wish leave the addin loaded as long as one of these files
remains active. ANy ideas on this?