Hi,

About a year ago I wrote C++ excel add-in, which provides a few worksheet
function which I still use quite frequently and successfully. Now I want to
use the same function in VBA. From what I understand, I need to add a
reference to the add-in first, but when I pick my xll from the browse menu,
I get the "Can't add a reference to specified file" error. Something is
probably screwed inside my xll. Can you recommend what I should look at.

Many thanks!

Bura.

PS: The function that I want to use is one that takes a URL and returns the
contents of that resource. In particular, I'm running a few servers and I
need for my VBA code to find the live ones. So I request an
http://serverN/AreYouAlive.jsp, and the server replies "yes" and my function
passes it through, or the request time outs and my function returns "no". In
VBA I would like to be able to say if getURL(http://serverN/AreYouAlive.jsp)
= "yes"... Perhaps someone could suggest an alternative way of doing this
and then the primary question is this post will become moot. Thanks again.