-
Simple question
I am writing to a text file some values wich are separated by ","
unfortunatly when The file is written the values are encolsed in "
this realy dose not help me, what could I do?
Data= 123,123
open "Data.csv" for ouput as #1
write #1, Data
close #1
the file contains
"123,123"
How do I get rid of the "
THanks
Santiago
-
I ran your code with a few minor sp errors and it worked for me.
it ends up as a comma seperated value file that is opened by MS Excel.
Code:
Private Sub Command1_Click()
Dim data As String
data = "123,123"
Open "c:\Data.csv" For Output As #1
Write #1, data
Close #1
End Sub
This and let me know
-
Use
Print #1
instead of write