LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"