Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |