Can't find project or library

  • Thread starter Thread starter Roy
  • Start date Start date
R

Roy

Excel XP cannot find MID, RIGHT or LEFT functions....
What reference library are they located in?

Thanks!
 
Roy,

They are located in the VBA library, typically located in
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
.. If this library is marked MISSING in the References dialog,
you should unregister then reregister Excel with Windows.

Close Excel, then go to the Windows Start menu, choose Run, and
enter
Excel.exe /unregserver
Then, run Excel again with
Excel.exe /regserver

Finally, start Excel normally.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Just to add some additional considerations:
And if any other library is marked as MISSING, you need to either unselect
it (if it isn't used) or use the browse button to find it on your machine.
This is often the cause of the error you are getting even though the cited
functions are not included in that missing library.
 

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

Can't find project or liabrary 2
object library problem 2
Can’t find library 2
Can't find project or library 3
missing library makes Format() disappear 2
Excel 2003 with VBA - "Can't find project or library" 6
Compile Error: Can't find project or library 3
Can't find project or library (Mid Function) 4

Back
Top