How can I...
Ok, I have a Visual Basic program that I would like to use to send
information into a worksheet designated as a Common Seperator Value file. So,
in my program I have set a single variable to contain all information for one
line seperated by commas (,) to distinguish which part of the line goes into
which column. Now, as it stands this works beautifully with one MAJOR
exception- Every time I send the 'line' to the CSV file, it simply overwrites
the previous data. What I want to happen is when I send the info to excel it
follows these steps (or at least to this effect):
1. Open the CSV file
2. Write Ln
3. Drop the cursor to the next row
4. Save and close the file
Can anyone help with this?
|