ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA XP to 2000 problems (https://www.excelbanter.com/excel-programming/298050-vba-xp-2000-problems.html)

Leon[_4_]

VBA XP to 2000 problems
 
I programmed buttons in office XP with functions like
UCase or flag, but when I want to run this on excel2002
or excel2000 then I recieve an error stating "project or
library not found". I tried to save the worksheet as a
microsoft excel 95-2002.xls file, but this did not help,
any ideas? Thank you.

Harald Staff

VBA XP to 2000 problems
 
In the VBE go Tools References and see what's MISSING. Try unchecking them
and see what happens.

And also:

For L = 1 to 100
MsgBox "I will develop using the oldest version"
Next

HTH. Best wishes Harald

"Leon" skrev i melding
...
I programmed buttons in office XP with functions like
UCase or flag, but when I want to run this on excel2002
or excel2000 then I recieve an error stating "project or
library not found". I tried to save the worksheet as a
microsoft excel 95-2002.xls file, but this did not help,
any ideas? Thank you.





All times are GMT +1. The time now is 04:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com