Results 1 to 2 of 2

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

  1. #1
    Join Date
    Nov 2011
    Posts
    61

    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.

  2. #2
    Join Date
    Mar 2011
    Posts
    542

    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

Similar Threads

  1. How to ASP.NET data will be output directly into Excel format
    By Savannah87 in forum Software Development
    Replies: 4
    Last Post: 12-02-2010, 04:58 AM
  2. Convert Excel data to HTML Table
    By Chalina in forum Software Development
    Replies: 2
    Last Post: 04-08-2009, 11:21 PM
  3. Export data from excel spreadsheet to an Oracle Table
    By Kurtz in forum Windows Software
    Replies: 2
    Last Post: 13-05-2009, 01:11 PM
  4. A Data Table in Microsoft Office Excel
    By kattman in forum Guides & Tutorials
    Replies: 7
    Last Post: 29-04-2009, 05:58 PM
  5. Auto filling linked data from another table in Excel 2007
    By Samarth in forum Software Development
    Replies: 2
    Last Post: 25-12-2008, 08:04 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,635,251.57102 seconds with 17 queries