Thread: How can I...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
markythesk8erboi markythesk8erboi is offline
external usenet poster
 
Posts: 28
Default 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?