I'll be darned... You are correct. I have always added the extensibility
library. It appears to be working without the reference.

When do you need the reference? I have always gone by Chip's site for this
kind of thing... Are there any objects, properties or methods that require
the reference?

http://www.cpearson.com/excel/vbe.aspx
--
HTH...

Jim Thomlinson


"Peter T" wrote:

There's no problem at all to use Extensibility with Late Binding.

Simply change any object declarations to 'As Object' and replace any named
constants with their intrinsic values, along the lines as I indicated in my
other post (which I assume directly answers the original question).

Regards,
Peter T

"XP" wrote in message
...

I thought that might be the case, but this forum would be the place to
check.
Thanks Jim!

"Jim Thomlinson" wrote:

You can't. You are trying to look into the VBE to analyze code. There is
no
late binding option for such a thing that I am aware of.
--
HTH...

Jim Thomlinson


"XP" wrote:

Using Office 2007 and Win XP;

If possible, could someone please modify the following function in such
a
way that I would no longer have to reference Microsoft Visual Basic
Extensibility? (watch for line wrapping)

Public Function ProcedureExists(argProcedureName As String,
argModuleName As
String) As Boolean
'returns true if a procedure already exists:
On Error Resume Next
ProcedureExists =
ActiveWorkbook.VBProject.VBComponents(argModuleNam e).CodeModule.ProcStartLine(argProcedureName,
vbext_pk_Proc) < 0
End Function

Thanks much in advance for your assistance.