Hi folks,
strange thing...can't explain why it happens. In my code for an Excel application I use the built-in functions Left- and Right, like in: [VBA]Msgbox Right("This is a test", 5)[/VBA] Which normaly reults in displaying a message box with "test". I so happens in all (new) files, except for the one I have been working on for quite some time. The machine I use in the office uses W2K and Office XP, at home I use WXP and Office 2000. This afternoon, in the office, the code ran wiithout a problem, but at home I get a message
Compile Error:
Can't find Project or Library
I have not a clue why this happens. I do not load any special add-ins, I tried it out on two other machines (W2K/Office 2000) with same result .
Why doesn't it run in this file, and without problem in other (new) files ? If any of you have a clue, plse help me out.
Regards,
Thymen