Compile error

G

Guest

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?
 
N

Norman Jones

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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compile error 3
Compile Error: with VBA call to "Format" 9
Can't Find Project or Library 2
Porting from Excel 2003 to Excel 2010 12
Compile Error "Invalid Outside Procedure" 1
The use of VBA function "Time" in an Excel Macro 6
Compile error hidden module 4
Chr$ 3

Top