CDate fails to convert when system in different locale

I've done some research and I have not found any solution so I am positing it here to see if it is REALLY impossible before I give up

I have a macro that reads some cells coming in a "dd mmm yyyy" format as a string, where mmm are the three-letter abreviation in ENGLISH. To read it I replace spaces as hyphons and use CDate. No problem here, since I set my system with english formats.

however when run from a spanish locale computer Cdate fails to convert it to date.

is there any function that can do the trick?

the macro involves numerous date comparisons, so better if it is something simple


thanks!

If the inputs are always English/American then you should find you can use Evaluate

Please Login or Register  to view this content.

the above would work on both UK & Spanish Locale

works like a charm, THANK YOU!