View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
James Ravenswood James Ravenswood is offline
external usenet poster
 
Posts: 143
Default Using Excel VBA: sending output data table to created .csv file +append Options

On Dec 8, 1:22*pm, Mike wrote:
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