View Single Post
  #1   Report Post  
First VP
 
Posts: n/a
Default How do I auto save worbook at end of line

We are running a program called COLLECT XL which takes a serial data stream
and writes it into a woorksheet. We are using Visual Basic Editor to "Save
Workbook on Change". This causes the entire workbook to be saved 17 times
because we have 17 different fields of data for each line. Is there somway to
save the workbook only at the end of each line of data? The data stream ends
with a carriage return {13}.