How to use Excel VBA to send output data table to created .csv file with options?
Hi everyone, Say I have already XVar.csv file and using MS VBA 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 a lot in advance.
Re: How to use Excel VBA to send output data table to created .csv file with options?
Well you can use the below mentioned command and let me know whether it is working or not.
Code:
Sub UpdateCSV()
Open "C:\TestFolder\junk\AA.csv" For Append As #1
Print #1, "Hello World"
Close #1
End Sub