Accessing the functions inside an add-in?
 

I've created an add-in. I would like to make the functions in it available
to other VBA programmers. I figure the programmer would need to Reference
the add-in. What can I do to my add-in code that would allow its functions
to be accessed by outside modules? My add-in is not contained in a Class
module...does that matter?
--

Toby Erkson
http://excel.icbm.org/

Accessing the functions inside an add-in?
 

Nevermind, I figured it out.
--- Code Start ---
Sub test()
Dim dummy As String 'My function does return a value

dummy = Application.Run("SAP_Data_Assistant.SAP_ReturnData Path", _
"C:\Excel\OTS\SAP OPOS Output File.xls", "",
Sheets("Where").Range("A2").Value, False)

Sheets(1).Range("A1").Value = dummy
End Sub
--- Code End ---
My add-in is named "SAP_Data_Assistant.xla" and the function I want to use
is "SAP_ReturnDataPath" (it has a parameter list but that's not important
here).

Basically it's:
Application.Run ("add-in name.function"[, paramater1][,parameter2][,etc.])

For simple functions:
Application.Run "add-in name.function"

Suggestions for a better way are welcomed :-)
--

Toby Erkson
http://excel.icbm.org/


"Air_Cooled_Nut" wrote:

I've created an add-in. I would like to make the functions in it available
to other VBA programmers. I figure the programmer would need to Reference
the add-in. What can I do to my add-in code that would allow its functions
to be accessed by outside modules? My add-in is not contained in a Class
module...does that matter?
--

Toby Erkson
http://excel.icbm.org/