Thread: csv files
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
linto linto is offline
external usenet poster
 
Posts: 8
Default csv files

I have created a macro to open a csv file and copy the contents to another
file.
When i run the macro in my system it opens the csv file and in this file all
the data are in seperate columns. but when i run this macro in another system
it opens the csv file but in this file the data are in single column
seperated by commas.

is there a settings difference in different computers that make then open
the csv files differently. how to change this setting in the macro so that
the csv file opens similarly in all systems like each data in different cells
rather than in in one cell seperated by commas