Finding out if subroutines exist in another workbook

[Erich Neuwirth]

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?

 

[Bob Phillips]

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)