I am trying to build a wizard with a form based GUI to facilitate the
use of functions supported by an excel add-in. Each function has a set
of required parameters. I will use a text box on the form for the user
to input each value to be passed to the parameters of the addin
function. Is it possible to interrogate the addin to have an array
returned telling me the required parameters? In the same way that the
object explorer can tell you e.g.,

Function AddInFunction(Parameter1 As Long, Parameter2 As Date,
[Parameter3 As Date])

Member of MyAddin.Main

Just to be able to assign that lot to a string variable would be
awesome. The idea being that my addin wizard would be flexible to any
changes made to the addin. From reading prior posts it seemed like
this might be possible using a TypeLib API method. However when I run
the necessary code on the MyAddin.xla file itself I get an error
saying the file doesn't contain a valid TypeLib. The addin does ship
with a library file but this seems to list only the activex functions
called by the addin and not the functions the addin offwers that act
as a wrapper to these active-x calls. Am I trying to do something that
is not possible?