Yep. Just type D.T.APPL.ACTIVEWORKBOOK.SAVE
into your Actions window after the status update and it will save. I use it all the time! -Tom Marquis North Kansas City Hospital From: [email protected] [mailto:[email protected]] Sent: Tuesday, August 30, 2011 3:55 PM To: [email protected] Subject: [talkbws] Saving Excel updates in DataStation Hello, I need to process a large file of credits from an Excel workbook into STAR. I'll be updating each row in the file with a status reflecting the failure/success of each transaction. Is there a way to save the status updates back to Excel without waiting until the script gets to D.Close_ ? If the script hangs up for some reason and has to be restarted, I have to be 100% that transactions are not applied more than once. Thanks! David Garcia Sr. Programmer/Analyst Washington Hospital, Fremont California (510) 745-6477 --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s), and may contain privileged or confidential information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please notify the sender of this email, and destroy all copies of the original message. --- To post a message to this list, send mail to: [email protected] You are currently subscribed as: [email protected] Unsubscribe in the customer center on our website: http://www.bostonworkstation.com/customer_center/virtual_user_group_talk.aspx
