ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Excel VBA: sending output data table to created .csv file +append Options (https://www.excelbanter.com/excel-discussion-misc-queries/270644-using-excel-vba-sending-output-data-table-created-csv-file-append-options.html)

Mike

Using Excel VBA: sending output data table to created .csv file +append Options
 
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

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


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com