ceal21c
05-25-06, 10:47
Hey Guys,
How can I save a string (or array) as a comma seperated value? I can read csv files and store the data as a string or an array but when I try to save the data after I have edited it, it looses the csv format and is saved as one long line.
This is the code I use to read the data:
Open "c:\XFER\Users\users.csv" For Binary As #1
strUserList = Input(LOF(1), #1)
Close
And this is the code I use to write data:
Open "c:\XFER\Users\users.csv" For Output As #1
Write #1, strUpdatedUserList
Where am I going wrong?
How can I save a string (or array) as a comma seperated value? I can read csv files and store the data as a string or an array but when I try to save the data after I have edited it, it looses the csv format and is saved as one long line.
This is the code I use to read the data:
Open "c:\XFER\Users\users.csv" For Binary As #1
strUserList = Input(LOF(1), #1)
Close
And this is the code I use to write data:
Open "c:\XFER\Users\users.csv" For Output As #1
Write #1, strUpdatedUserList
Where am I going wrong?