Addin Name
Hi Jason
I take it the addin is not an installed addin and your code already
successfully opens the file. To run a proc' in this addin from elsewhere
something like
Application.Run "MyAddinName.xla!Module1.proc_name"
add any arguments separated by comma's
If your addin is always loaded, eg installed, and you are only using other
code in the same system then you could set a reference in Tools/References
to the project name of the addin. Beforehand ensure the addin has a unique
project name. In code that already has the reference set -
myAddinProjectName.proc_name
or if you are sure "proc_name" is not duplicated in any other referenced
file, simply
proc_name
Regards,
Peter T
"Jason Zischke" wrote in message
...
Hi All,
I've got a sub the gets the user to open a file that is an addin like file
however I can't get the Name property of the addin to be able to reference
it. So, is the a way to get this name?
Jason
|