Thymen
02-24-2006, 02:28 PM
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: Msgbox Right("This is a test", 5) 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 resulthttp://vbaexpress.com/forum/images/smilies/banghead.gif .
Why doesn't it run in this file, and without problem in other (new) files http://vbaexpress.com/forum/images/smilies/102.gif ? If any of you have a clue, plse help me out.
Regards,
Thymen
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: Msgbox Right("This is a test", 5) 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 resulthttp://vbaexpress.com/forum/images/smilies/banghead.gif .
Why doesn't it run in this file, and without problem in other (new) files http://vbaexpress.com/forum/images/smilies/102.gif ? If any of you have a clue, plse help me out.
Regards,
Thymen