complile error: switched to windows XP from 2000

[ologist]

Hello,

I have switched to Windows XP from 2000 and now my macro won't run.

I get: Compile Error- can't find Project or library. It highlights my variable name fName, so I assume Excel has changed fName to something else. If anyone knows what the new variable name is and could let me know I'd sure appreciate it!!

 

[DeSn]

Try this:

Tools -> References

And there you will she that there is a library or something like that that is checked on and starts with MISSING:
Where you remove this, everything will work again.

 

[JohnAcc]

Cheers DeSN !

This was doing my head in for days !