I have some extensive VBA code that reads emails, deciphers information, looks up additional data and updates the information in an Excel spreadsheet that is shared between two user Office 365 accounts. The other user also updates the same spreadsheet on line (actually it's done via an AppSheet app).
The problem is that I frequently lose data. When the online user updates information, and at a similar time my VBA updates data on my PC and then syncs, the PC version over-rides the on line version and on-line updates are lost. At the end of each day I need to laboriously go through version histories on line copying data from one copy to another to come up with a final result for the day.
AppSheet suggest I use Google Sheets instead of Excel, but that would mean a major re-write of my VBA, so I was hoping someone might have a better solution.
Ideally I would like to create a virtual drive link to the on-line version of the spreadsheet and get the VBA to update that. I know that could be done if the spreadsheet was not shared between two users, but because it is, Microsoft won't support the virtual drive link.
