Project/Library not found issue

[boylejob]

I have recently been upgraded to Excel 2007 and I am running into some problems. One of the programs I run constantly does a simple conversion of a social security number to elimination the dashes (123-45-6789 gets converted to 123456789). The code below has done for me for years where ID is the old social security number and ssn will be the converted social security number

Please Login or Register  to view this content.

I am now getting an error when that says "Cannot find project or library" and Left in the the above code is highlight. I feel that in the VBA editor under Tools one of the References needed has not been checked. There appears to be about 200 references available and I haven't got the slightest idea which one might not be checked that should be.

In the past when I was in the VBA editor debugging a program I could place my cursur over a variable and it would give me the value of that variable in a little box near the curser. Now that I have Excel 2007 it has stopped doing this. Is this feature not in 2007 or is there a switch I need to flip to get that turned back on.

Can anyone help me with these two problems?

[davegugg]

The four references that I keep checked as a default are (in order):
Visual Basic for Applications
Microsoft Excel 12.0 Object Library
OLE Automation
Microsoft Office 12.0 Object Library

I'd guess your problems are linked. Let me know if making sure these references are linked in the same order I have does not remedy your problems.

[shg]

Look for a reference that says MISSING and untick it.

Please Login or Register  to view this content.

[boylejob]

davegugg: I have the same references checked so I don't guess that is the problem.

shg: I did not see I had a reference called MISSING to untick. I did replace my code with what you provided and that has solved my problem.

Thanks!