Along a similar note, I've noticed that if you have a spreadsheet opened in Datastation, and you open the same file, even externally to the scripting pc, it will cause issues with your Datastation connection to the file. Not sure if it kills the connection or resets your pointer in the file or what, but script will not work until you close the DS connection and reopen, and navigate back to your location.
Recommend copying the file to another location and opening it on another pc to prevent this if you need to view the contents of the file while scripting it. From: [email protected] [mailto:[email protected]] Sent: Wednesday, May 21, 2014 7:58 AM To: [email protected] Subject: [talkbws] Excel behavior that can impact stored data inside a .BDS file Good morning all, I recently discovered this behavior in Excel. http://support.microsoft.com/kb/826741 This has some ramifications for .BDS files (or anything else that looks at the modified date of an .XLS Excel file - I haven't seen the behavior with .XLSX files) If you open a .XLS manually with Excel 2007+, then very quickly - close it and then open the file with the DataStation, there is a good chance BWS will see the "temporary" filetime, rightfully think that it is a new file and clear the .BDS file. This isn't a bug in the DataStation. It is working the way it should. But, basically this means, to make sure this Excel behavior doesn't cause you grief... If you have an Excel file that you ran an automation against, it wrote to D("Status") etc., and you stopped it, or need to do further processing. Do not open that spreadsheet in Excel until you're done with the D("Status") data. Regards, Thom --- To post a message to this list, send mail to: [email protected]<mailto:[email protected]> You are currently subscribed as: [email protected]<mailto:[email protected]> Unsubscribe in the customer center on our website: http://www.bostonsoftwaresystems.com/Customers/ListServe.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.bostonsoftwaresystems.com/Customers/ListServe.aspx
