Using Excel VBA: sending output data table to created .csv file +append Options

[Mike]

Hi everyone,

Say I have already XVar.csv file and using MS VB I want to automate
writing a data vector X[a,b,c] to XVar.csv or appending it to already
existing table in XVar.csv

How this could be written in a simple vba code?

Thanks,
Mike

 

[James Ravenswood]

Hi everyone,

Say I have already XVar.csv file and using MS VB I want to automate
writing a data vector X[a,b,c] to XVar.csv or appending it to already
existing table in XVar.csv

How this could be written in a simple vba code?

Thanks,
Mike

Sub UpdateCSV()
Open "C:\TestFolder\junk\AA.csv" For Append As #1
Print #1, "Hello World"
Close #1
End Sub