CODEWITHSUNDEEP
excelvba
Stuart Cruickshank
Stuart Cruickshank

Reputation: 65

Excel VBA not writing to next text file line

I have the following macro that is should write new data onto a new line in a text/csv file, however it overwriting the existing text in the file, I thought that write wrote to a new line as opposed to print. I am not sure what I am doing wrong

Sub picking()

Range("d14").NumberFormat = "mm/dd/yyyy"
Range("d14").Value = Now

Range("e14").NumberFormat = "hh:mm"
Range("e14").Value = Now

Range("e17").Value = "Picking"

Call outputcsv

End Sub



Sub outputcsv()

Dim Fullpath As String
Dim outputstring As String

Fullpath = Worksheets("Maintence").Range("c5")

Open Fullpath For Output As #1
outputstring = Worksheets("CSV").Range("A1")
Write #1, outputstring
Close #1
End Sub

Upvotes: 0

Views: 355

Answers (1)

John Joseph
John Joseph

Reputation: 1175

You just need to change...

Open Fullpath For Output As #1

...to...

Open Fullpath For Append As #1

Note that "Output" changes to "Append."

Also note that "Append" will create the file - just as Output does - if it doesn't already exist. No need to pre-create it.

Upvotes: 1

Related Questions