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

You could rename/copy the file to have an extension of .txt. Then your macro
would parse the data as comma separated. In fact, you'd have more control of
how each field is treated instead of just letting excel guess at each field.

I think the problem with the troublesome pc's is that their windows regional
setting is different from yours. They don't use a comma as a list
separator--maybe a semicolon (common in non-USA locations).

linto wrote:

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

--

Dave Peterson