You can test to see if the file is in use before and act accordingly. You can save the file with a time-stamped name (myfile-20060826-130405.xls).
You can force the other users to open the current file as read-only, which it would seem, they should be doing anyway to ensure that conflicting changes are not made. I am sure there are other approaches that the folks here will mention. HALinNY => -----Original Message----- => From: [EMAIL PROTECTED] => [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] => Sent: Monday, August 28, 2006 10:11 => To: [email protected] => Subject: Replacing a file that's in use => => Hi, => => What's the best way to deal with replacing a file that's in => use? I have a FoxPro program that imports a text file, => massages it a bit, loads it into Excel via automation, makes => some formatting changes and then does a save as to an => existing XLS file. Trouble is sometimes that Excel file is => in use and the program fails. I then have to track down => who's using it, redo the process, etc. => => Wondering how other people have dealt with this. => => Andrew Baker => Sr. Information Resources Analyst _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
