We have a macro which does some processing and generate a dat files. Ou
company has some customer in Europe. Can it is possible I can defin
locale globally for a macro and all the processing will happening base
on that locale, irrespective of the local at the operating system level


-Thanks
Ra

--
iamraj
-----------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...fo&userid=2811
View this thread: http://www.excelforum.com/showthread.php?threadid=48229

the short answer is no, unless you use the API to change the settings

to see an excellent source for these type issues, see Stephen Bullen's site.

He recently posted:


There's much more about these types of issue in my 'International
Issues' chapter of John Green's "Excel 2002 VBA Programmer's
Reference", which can also be read online on my web site, at:
http://www.oaltd.co.uk/ExcelProgRef/ch22/

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


--
Regards,
Tom Ogilvy

"iamrajy" wrote in
message ...

We have a macro which does some processing and generate a dat files. Our
company has some customer in Europe. Can it is possible I can define
locale globally for a macro and all the processing will happening based
on that locale, irrespective of the local at the operating system level.


-Thanks
Raj


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile:
http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=482291

Thanks for the suggestion, it is very helpful.

I tried to look for window API by which I set the locale at workbook
level irrespctive what we have for windows operting system but had
no luck on that.

Does any body know to set the locale at workbook level.

-Thanks
Raj


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=482291