ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I auto save worbook at end of line (https://www.excelbanter.com/excel-worksheet-functions/46583-how-do-i-auto-save-worbook-end-line.html)

First VP

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


All times are GMT +1. The time now is 06:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com