Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel File Already Open, Can't Copy To
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel File Already Open, Can't Copy To
Divers
Thread ID:
00582389
Message ID:
00582389
Vues:
55
I have an app that generates Excel reports using "COPY TO (lcFile) TYPE XL5" where "lcFile" is a filename generated by the date (ie. "report_20011225.xls"). If someone runs the report, which automatically opens in Excel, then keeps it open and later re-runs it (happens very often) then they get a "LOCK FILE VIOLATION" error and the new report can't open. How can I check to see if a file is open already? I tried using an error handler to change the filename, but keep getting a MISMATCHED PUSH/POP error. There has to be a better way...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform