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