library Problems with office 2007

andy

Hi, we recently upgraded from office 2003 to office 2007. In excel, I have a few macros that are now saying "Compile Error: Can't find project or library".
The lines of code that are highlighted include
Environ("username")
Lcase()
Format()
How do I resolve this? I find it hard to believe that these common elements would not be included as a standard part of Office.

It's probably not these items that are in error. I've noticed that items in the Strings library in particular tend to serve as the canary in a coal mine, and show an error when there is a missing reference elsewhere in the project. Go to the VB Editor's Tools menu, choose References, and uncheck any that are displayed as "MISSING:"

Ok, great. So far that seems to be working. Thanks for your help.