Hello All,
I have the following code below which writes to my CSV file successfully.
Now how do I get it to write a new record on the Next line/Row?
Thanks for the help!
Regards,
James
I have the following code below which writes to my CSV file successfully.
Now how do I get it to write a new record on the Next line/Row?
Code:
Dim objWriter As IO.StreamWriter = IO.File.AppendText(_strCustomerCSVPath)
If IO.File.Exists(_strCustomerCSVPath) Then
objWriter.Write(_CustomerID & ",")
objWriter.Write(_FirstName & ",")
objWriter.Write(_LastName & ",")
objWriter.Write(_Phone & ",")
objWriter.Write(_Email & ",")
objWriter.Write(_Address & ",")
objWriter.Write(_City & ",")
objWriter.Write(_State & ",")
objWriter.Write(_ZipCode)
Else
MsgBox("Does not exist")
End If
objWriter.Close()
Thanks for the help!
Regards,
James
Comment