Excel 2010 on Windows 7

[MikeDBMan]

I have used Excel 2010 for quite some time. But I just was upgraded to Windows 7 from good old XP. Now some of my VBA code won't run. For example, I use the function Left() in the context of

Let TheFile = Left(TheFile, Len(TheFile) - 1)

I get an error Compile error: Can't find library or project.

I get the same message on a function String$(). I am sure there are others. Obviously I need to install some plug-in or something. Suggestions?

 

[VoG]

Check for missing references http://www.cpearson.com/excel/MissingReferences.aspx

 

[MikeDBMan]

The resource: Active Setup Control Library was "MISSING:". I just unchecked it, saved the file that seemed to cause the "error" and when I reopened it, everything seems fine. Would you agree that I would not need to try to install that missing resource? I can't find where to get it anyway. Thanks for the help.

 

[VoG]

If it is now working I would leave well alone