How to remove quotation marks from my worksheet output ?

[redsab]

Hello,

I have an excel program that reads a file and prints it to the work sheet, but I can't figure out why it puts quotation marks around the line of text. I would like to remove the quotation marks from column A and column D. Does any one have an easy solution? Thanks!
redsab

[humdingaling]

your csv file has quotation marks around every line which is why its putting it your file at start and end
"Employee ID,First Name,Last Name, Salary"

Change this line

line = txtstrm.ReadLine

to

line = Replace(txtstrm.ReadLine, Chr(34), Chr(32))

^^ this code just replaces the " with space

[redsab]

humdingaling, Thanks for noticing the quotes. I used Excel to write the .csv file and it must automatically place quotes for each line, because my original file did not have quotes. Well, I like your version better than mine, I'll use that, thanks!
redsab

[6StringJazzer]

The reason you are getting quotes in your output is that there are quotes in your CSV file. This is what it looks like if you open it in a text editor instead of Excel:

"Employee ID,First Name,Last Name, Salary"
"222312,Marc,Ariberti,933710.4"
"29287,Stephan,Assmus,123005.4"
"268218,Olivier,Aubert,1126515.6"
"262737,Sigmund,Augdal,1103495.4"
"122696,Pierre,Baillet,515323.2"
"114502,Gildas,Bazin,480908.4"
"53983,Rocky,Bernstein,226728.6"
"190374,Stephane,Borel,799570.8"
"391579,Arnaud,de,1644631.8"
"368256,Filippo,Carone,1546675.2"

[redsab]

Jeff, that's what humdingaling pointed out. I did not notice that. Thanks for your observation.
redsab

[redsab]

I came up with a work around myself!
redsab