RE: [Talk] Writing back to a spreadsheet

[Swisher, Vincent J.]

Datastation creates a log file called <filename>.xls.bds  In this file are the statuses of each entry.  What you you could do is generate a report from datastation and import this into a spreadsheet.   Depending on how large you spreadsheet is, it could take a while to generate the report file.  I would suggest you be patient while the report is generating.   What I typically do is import my data into an Access Database and write the statuses directly to the database.  This is much easier and if the script needs to start over because of some issue with the screen, you don't have to wait while the script finds the last record you were on before the script stopped.   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Paul Brungardt Sent: Monday, November 29, 2004 2:00 PM To: [EMAIL PROTECTED] Subject: [Talk] Writing back to a spreadsheet I am writing a script pulling in info from a spreadsheet via datastation.  I would like to write a status of done next to each record and have the status show in the spreadsheet.  So far, I can not find a way to do that.  I can see the status while using datastation, but not while viewing the spreadsheet alone.  Anyone have a way of doing what I am trying to do? Thanks! Paul     Paul Brungardt Clinical Analyst HaysMedicalCenter PH: 785-623-2196 PG: 785-650-5989   See our web page at http://www.lahey.org for a full directory of Lahey sites, staff, services and career opportunities. THIS MESSAGE IS INTENDED FOR THE USE OF THE PERSON TO WHOM IT IS ADDRESSED. IT MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If you are not the intended recipient, your use of this message for any purpose is strictly prohibited. If you have received this communication in error, please delete the message and notify the sender so that we may correct our records.