Thread: Addin Name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default 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