Open CSV as a text file ?

[tsil]

Hello

I have a csv file that I like to open up as a .txt file,

the reason is that the content is separated with ";" not with "," so when
the text contains "," the .csv file will separate that into another cell eventhough
it should just treat it as content between ";"

If I change the .csv with .txt then it works fine but I cannot do that with
a makro in excel without open up the .csv file...

Also if I open up the csv manually and deliminiate it, it will work, I have recorded that
as a makro but it does not work when running it as a makro.

Anyone have had the same problem and solved it...?

BR
/Tommy

 

[jbeaucaire]

You should be able to open the CSV as a text file, thus putting all the data into column A. Then run a TEXT TO COLUMNS on that column A using the "other delimiter" of ";" and it will split your data for you, faster than converting to commas then splitting.

 

[Norie]

You can change the name of the file using code.

Name "Filename.csv" As "filename.txt"

That's a simple example, you'd need to add paths etc.

You could also turn on the macro recorder when you open the file manuallly and delimit it to get code.

 

[tsil]

YES!!

This was excactly what I looked for, the "Name ... as ..."
It works perfectly , thanks Norie !

BR
/Tommy



ps, I did record a makro doing what I wanted but when I ran it, it did not work.


pps. to jbeaucaire, I tried to open it up as textfile but it still used the commas as separators. The "Name .... as ..." works great though.