View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Using VBA to temporarily bypass regional options

Doesn't it already do that? It is certainly my understanding.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Carim" wrote in message
oups.com...
Hi all,

Is there an elegant way of temporarily asking VBA to stick to its
embedded US core settings, in order to format dates accordingly ...,
and then, once action has been performed, to return to its regional
settings ...

Thanks for all your comments
Cheers
Carim