Is there a way to avoid conflicts syncing with Excel on Google Drive?
I’m trying to keep a delivery list up to date during the day. I’ve written VBA code that reads emails as they arrive, dissects relevant details, runs a few functions that I can’t do with Google Script, then updates or adds the record in an Excel spreadsheet.
I’ve also written an AppSheet App to help me plan the deliveries, record the details and take some photos.
However I have a real problem using Excel. If Outlook is processing the Excel spreadsheet while the App is updating it, the Spreadsheet wins and my App update is lost.
I know it would work much better with Google Sheets but I don’t have the skill to read and write to a Google Sheet with VBA.
Has anyone found a solution that I could use to overcome my problem? I’d rather not try to keep an Excel and Google Sheet in sync as I fear problems