Finding out if subroutines exist in another workbook
 

I need some functionality in an addin.
When a certain procedure in the addin in executed,
it should check for the existence of the a procedure with
a fixed name in the active workbook, and if the procedure
is defined, it should execute it.
So: how can the addin check if the ActiveWorkbook
has a procedure of a given name?

Finding out if subroutines exist in another workbook
 

Something like?

On Error GoTo err_label_1
Debug.Print Application.Run("'QDE.xla'!GetDatePriority")
Debug.Print "Found"
Exit Sub

err_label_1:
Debug.Print "Not Found"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Erich Neuwirth" wrote in message
...
I need some functionality in an addin.
When a certain procedure in the addin in executed,
it should check for the existence of the a procedure with
a fixed name in the active workbook, and if the procedure
is defined, it should execute it.
So: how can the addin check if the ActiveWorkbook
has a procedure of a given name?