can't find project or library in Excel 2003 VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My VBA macro uses Instr and Left successfully but Mid or Right cause the
"can't find project or library" error. Mid and Right are present in the
object browser along with Left and Instr. How can I enable them?
 
Hi
in the VBA editor goto 'Tools - References' and make sure the Excel
library is checked
 
Hi D,
My VBA macro uses Instr and Left successfully but Mid or Right cause the
"can't find project or library" error. Mid and Right are present in the
object browser along with Left and Instr. How can I enable them?
Click to expand...

Go to Tools > References and untick the ones labelled 'MISSING:'

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 

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

VBA errors in 2007 (works fine in 2003) 14
Can't find project of library 3
Access 2007,reports,VBA 2
Can't find project or liabrary 2
Excel 2003 with VBA - "Can't find project or library" 6
Copying part of a header from active word document and pasting in excel using VBA 0
Embedding Indirect.ext 2
Connected from Excel to Access 3

Back
Top