VBAProject name compile error, not defined at compile time

VBAProject name compile error, not defined at compile time

Post by Matthew Do » Thu, 15 Dec 2005 04:09:45


How do I make this work?

If Not generalFunctions.isOpenWkb(strWkbStat) Then
Workbooks.Open (strPath & strWkbStat)
Call generalFunctions.addReference(strPath & strWkbStat)
End If
Set wkbStat = Workbooks(strWkbStat)

Call osteocht.chartIt.topPlot(Target)

This code opens workbook strWkbStat and establishes a reference to it
so I can call the code in the VBAProject called osteocht.

Problem is that this reference is not established at compile time, so
the perceived variable called osteocht (which is the name of the
VBAProject where the code I'm calling sits) is called as being not
defined ... end of party.

How do I get around this

Thanks in advance for getting me out of this empasse!

Matthew
 
 
 

VBAProject name compile error, not defined at compile time

Post by Bob Philli » Thu, 15 Dec 2005 04:17:15

You could try and force a compile in your code

Application.VBE.CommandBars.FindControl(ID:=578).Execute


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)