Add Reference to XL function (2003)

  • Thread starter Thread starter wpiet
  • Start date Start date
W

wpiet

Is there a way to reference an Excel user-defined function in Outlook VBA?
I created a Boolean function that, via a userform, accepts a username &
password & authenticates them against ActiveDirectory. The function is in an
Excel workbook & I can use it in VBA in any other Excel workbook by adding it
via Tools/References/Browse . . . in Excel VBE.
If I try to add it in Outlook VBE, it returns message, "Can't add reference
to the specified file."

Alternatively (preferably) is there somewhere else to create this function
so that it could be used in any Office application? From research, I believe
an Add-in would be ideal but I don't have Visual Studio & don't know what
other options are available.
 
You might want to post about calling an Excel UDF from outside Excel in an
Excel programming group, the people there would know about that and whether
an Excel COM addin can be referenced from outside.
 
Thank you, Ken. I will do that.
--
Will


Ken Slovak - said:
You might want to post about calling an Excel UDF from outside Excel in an
Excel programming group, the people there would know about that and whether
an Excel COM addin can be referenced from outside.
Click to expand...
 
Back
Top