Solved: Can't Find Project or Library

[gmulhall]

Hi,

I have a macro which has suddenly stopped running when it hits the line

Select Case Mid(strInput, 1, 1)

with error message - cannot find project or library

The Mid function is highlighted.

I tried re-installing MS Office (2007) but the error still occurs. It all works fine on my work PC but not on my home PC.

Any help appreciated.

Thanks,

Geoff

[Bob Phillips]

In the VBIDE, go to Tools>References. There you will see an item with MISSING: in its title. Uncheck that item and all should be well.

Report back with which library it was.

[matthewspatrick]

Geoff,

Go to the VB Editor and check your references (Tools|References in the menu). Chances are, one or more will be listed as 'missing'. For these libraries, try removing the reference(s) and re-adding them.

[matthewspatrick]

Sorry Bob, typing too slowly this morning :)

[Bob Phillips]

Sorry Bob, typing too slowly this morning :)

What's 2 minutes between friends :smile:

[gmulhall]

FIxed. Thanks so much guys !

[Bob Phillips]

What library was it?

[david000]

I tried re-installing MS Office (2007) but the error still occurs. It all works fine on my work PC but not on my home PC.


Does your work PC and your home PC have Excel 2007
Or
Was it Work 2003; home 2007???

I've run into this too.:(

[Bob Phillips]

This is caused by someone creating code on one machine, and having a reference to a library (usually a totally superfluous library), and then porting it to another machine that doesn't have that library or that particular version.

As we said, delete the MISSING item usually fixes it.

[gmulhall]

Hi,

There was nothing flagged as missing. I selected VBA Project and then deselected it - which I presume caused everything to reset and all worked fine thereafter.

I'm running the macro on 2007 at home and 2003 at work. It now runs fine on both.

Thanks again,

Geoff