Can't find project or library

R

Roy

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

Thanks!
 
C

Chip Pearson

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
 
T

Tom Ogilvy

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

Cumulative formula for word table 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
object library problem 1
Excel 2003 with VBA - "Can't find project or library" 6
excel spreadsheet functions written in vba 1
Can't find project or library 3
Can’t find library 2
Object libray invalid problem 0

Top