Thread: Problem with the file format xlCSV and a field separator
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sarimari sarimari is offline
external usenet poster
  
Posts: 3
Default Problem with the file format xlCSV and a field separator
When I save a sheet using File - Save as.. to a format CSV - the result
looks OK and like this using Notespad:
1;monday;jan;1,11
2; tuesday;feb;2,22

BUT when I'm using a simple marco for the same funtion, the result looks
like this:
1,monday,jan,1.11
2,tuesday,feb,2.22

Why are the field separators different doing function manual or using marco?
Reply With QuoteReply With Quote