Hi Bill,

Your observation about the extraneous dot resolved that problem for me --

Yes, that was my typo! Apologies and thanks also to Dave for spotting it.

---
Regards,
Norman



"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
Dave Peterson wrote:
You have your addin open?

Maybe it was just a typo:

X = Application.Run("MyAddIn.xla!.MyFunction",Y)
has an extra dot in it:
X = Application.Run("MyAddIn.xla!MyFunction",Y)

If that doesn't work, you should post the line you used.

Alternatively, you could add a reference to your workbook's project that
requires that addin.

Tools|references
point at the addin's project

Then you can use the function in that addin just like it was a built-in
function.

ps. It's always good to give each project a unique name.

Inside the VBE:
hit ctrl-r (to see the project explorer)
select your addin's project's top level
hit F4 to view the properties
change the (name) from VBAProject to something more meaningful.

(don't forget to save that addin.)

-------------------

Your observation about the extraneous dot resolved that problem for me --
thank you. Now I can go back to directly accessing the XLA file residing
in my xlStart folder and all is well. The add-in is permanently open in
my system since I use functions from it liberally.

Thanks Dave...

Bill