D.t.appl.activeworkbook.Save D.Next_
Will make certain you capture it on a record by record basis... Thanks, Travis D. Hanson, Senior Applications Analyst Anderson Hospital IT Department <http://en.wikipedia.org/wiki/File:Yellow_ribbon.svg> <http://en.wikipedia.org/wiki/File:Pink_ribbon.svg> <http://en.wikipedia.org/wiki/File:Gray_ribbon.svg> 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 --- 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
<<image001.png>>
<<image002.png>>
<<image003.png>>
