View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
 
Posts: 137
Default Using VBA to temporarily bypass regional options

Bob,

What I am facing is a French based environment, which needs to trigger
a English report to HQ ...
Format(Date,"mmmm") produces in French mars ...
whereas my objective is to have it show March ...
So far, I have cheated quite inelegantly... ans as wondering if a
couple of instructions could help me temporarily bypass the French
settings ...

Thanks for your comments
Carim