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}.
|