Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject name compile error, not defined at compile time
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBAProject name compile error, not defined at compile time
You could try and force a compile in your code
Application.VBE.CommandBars.FindControl(ID:=578).E xecute -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Matthew Dodds" wrote in message oups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Visual Basic: Compile error: Sum or Function not defined | Excel Worksheet Functions | |||
Incremental Numbering: Compile Error - Variable not defined | Excel Programming | |||
Debug/Compile VBAProject not available | Excel Programming | |||
Variable not defined compile error | Excel Programming | |||
Compile error, variable not defined | Excel Programming |