Reginal issue(Please help)

[iamrajy]

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

[Tom Ogilvy]

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" <iamrajy.1xzjkm_1131129603.2044@excelforum-nospam.com> wrote in
message news:iamrajy.1xzjkm_1131129603.2044@excelforum-nospam.com...
>
> 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
>

[iamrajy]

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