View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jason jason is offline
external usenet poster
 
Posts: 104
Default Adding Data from EXCEL to a TEXT file

Every day I have to add a couple of hundred lines of data to the
bottom of a list.I then need to bring the complete list back to excel
to analyse it.
Keeping the data and manipulating it purely in excel is no use,
because of severe date formatting problems.

It has been suggested(in order to overcome date formatting
problems) to put the data each day into a TXT file.How do I move a
list of data in excel to the bottom of a list that exists in a text
file? The subject data may be a couple of hundred rows long and upto
16 columns wide.

Any useful code would be greatly appreciated.

Jason