View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
podskubka podskubka is offline
external usenet poster
 
Posts: 2
Default VBA SAVEAS TXT DATA PROBLEMS

Hi
I have a macro which saves my excel sheet as a text file. There are
some cells which include date in dd/mm/yyyy format. When I run thi
macro VBA changes the date format into mm/dd/yyyy. This means it reads
day as month and vice versa.
Any ideas?

Thank you very much.

Pete