View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rob Edwards Rob Edwards is offline
external usenet poster
 
Posts: 17
Default date format change when opening file with vb

Hi,
I presume that you are using the OpenText method to import the
info, which has a series of two-element arrays.

If yes, then the second element is a data type that interprets the
info. Use '4' to ensure the data is set in the DMY format.

Rob Edwards

Always look on the bright side of life!

*** Sent via Developersdex http://www.developersdex.com ***