How to use Excel VBA to send output data table to created .csv file with options?

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.
Reply With Quote
#2
Old 04-01-2012
Erakna Erakna is offline
Member

Join Date: Mar 2011
Posts: 507
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

If you like this post then consider sharing it with others.