ExcelBanter - Compile error

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Compile error (https://www.excelbanter.com/excel-programming/387095-compile-error.html)

sam0344

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?

Norman Jones

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?

All times are GMT +1. The time now is 07:46 PM.