Adding reference to Solver in Excel messes up the reference path

[obaluse]

Hi,

I am using Excel 2003 SE. So, VBA code is working fine, but adding a reference to SOLVER and running macro starts generating compiler errors:

"Compile error: Can't find project of library" for example to code lines like

x = Ucase("test")

and to get it working one must use

x = Strings.Ucase("test")

Now without changing this kind of stuff everywhere, how to fix this? Or is it simply better coding practise to start using full path (starting from excel or workbook level) function calls everywhere in the code?

BR,
ob