Thread: Help with Date Format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dan V[_2_] Dan V[_2_] is offline
external usenet poster
  
Posts: 4
Default Help with Date Format
Hi guys

I have a sheet which opens up 5 other sheets in turn to obtain data.

4 of the sheets have info in columns next to a date column

(eg)

07/11/2007 : xxx : xxx
07/11/2007 : xxx : xxx

But when my VB opens the sheets the dates change from

07/11/2007 (UK) to 11/07/2007 (US).

I am using nothing other than "Workbooks.Open Filename:=FPATH & BO_TEMP" to
open the file. (FPATH and BO_TEMP are variables defined earlier in the code).

Any ideas on why this is?
Thanks!
Reply With QuoteReply With Quote