Append range to csv file

[jharaldson]

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.

[Tinbendr]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[jharaldson]

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

[Tinbendr]

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.

[jharaldson]

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

[Tinbendr]

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