Problem solved ! at list partially....
The solution is here : http://support.microsoft.com/kb/907337
("You receive an error message when you start Visual Basic for Applications code in an Access database")
I run this on WinXP and Win Vista both Hebrew enabled.
Solved the issue by changing the non-Unicode language setting on the computer where I am running the VBA code. Under Language for non-Unicode programs
on the Advanced
tab, changed it to English
So now it (The Splitter modules) runs fine.
The main problem resulting from this change is that some other programs would not show messages properly and would display ????? instead. but can still live with that (force all apps to dispaly english messages if you can).
It beats me why modules written in VBA (Methods in this case) without any Fonts relations would trigger errors related to Unicode handlling in the operating system !.
Microsoft to solve this.....
Thanks for your help.