Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error
I can open this macro from another computer but everytime I open it up from
my computer...it has a compile error for : QTextBox = Workbooks(SourceName & ".xls").Sheets("Database").Cells(i, 36) It says cannt find Project or library...whats wrong? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error
Hi Sam
With the workbook open on the problematic pc, try: Alt-F11 to open the VBE Tools | References | Find and uncheck a reference marked "Missing" --- Regards, Norman "sam0344" wrote in message ... I can open this macro from another computer but everytime I open it up from my computer...it has a compile error for : QTextBox = Workbooks(SourceName & ".xls").Sheets("Database").Cells(i, 36) It says cannt find Project or library...whats wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
error message: compile error, argument not optional | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) |