Greek and VBA

[tekfangr]

Hello to all,

I've built up a program which handles excel files (open, extract, close...). Everything works well when files names -or worksheet names- are written in western characters, but bugs as they contain greek characters. How can i make VBA handle correctly unicode based characters?

Many thanks for your help

 

[JerryKlmns]

I avoid my native languange characters, opos o Diavolos to livani. But the few times I've used them I hadn't any problems. Is it the characterset or some not allowes characters like / or ?

Could you use C:\ToArxeio~1.xls, the shortname of the file?

When does it happen? Open/Save/Delete/Create?
Gerasimos