Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Open an existing Excel file
Versions des environnements
Hi everyone,
I am working on a project where I am dumping info to an existing Excel spreadsheet, which is located on a local network, from multiple users though a VFP form. It works great however, I am worried when someone is in viewing this spreadsheet and someone else tries write to it, that I will lose the data. Is there a was to check and make sure that no one is using the spreadsheet before opening it and if there is someone using it then wait till they close it before it can be opened and the info can be inserted into it. I would like to have a message on the screen saying “Waiting… Spreadsheet is locked for editing by user_name”. I'm not sure if there is a property in the open command to handle this or not. Can someone help me with this? Thanks
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement