+ Reply to Thread
Results 1 to 6 of 6

Append range to csv file

  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Append range to csv file

    Hello all,
    What I am trying to do is append a range on my spreadsheet to a csv file. I found this code, it works but it appends everything in one row. I want it to be in 2 columns in the csv file.
    Any help would be awesome.

    thanks


    Please Login or Register  to view this content.
    Last edited by jharaldson; 05-31-2013 at 03:03 PM.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Append range to csv file

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Append range to csv file

    Thanks david but its not working. Here is what i am trying to accomplish:

    A B
    text text
    text text

    I want the the csv file to read as;
    text,text
    tex, text

    but with the set up now it is texttexttexttexttext

    thanks again
    Last edited by jharaldson; 05-30-2013 at 08:15 PM.

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Append range to csv file

    The statement to add the value to the function is missing.
    Please Login or Register  to view this content.
    This is how I code it.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Re: Append range to csv file

    test.csv here is a csv sample that i get when i run your code and my original code. This text here sample,text,,,,,,,,,,, is what the original file is and when i append i get whats right below it. I want it to look like the original.

    thanks again

  6. #6
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,138

    Re: Append range to csv file

    Here's the sample file I created. It generates the row/column as the excel sheet. Look at it with Wordpad.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1