Macro for Append to csv
Hi guys,
I'm new here, if I'm posting in the wrong place, feel free to yell at me.
I have a dynamic range, which is defined by the number of non empty rows in a worksheet. (typically 10-20 rows). The number of columns are awlays the same (6). So, If I have 10 rows, my range would be A1:F10.
Now, I need a macro to append this range to an existing csv file, and have no idea how to do it, my abilities with VBA are limited, to say the leat.
Any ideas?
|