I am trying to find a way to 'collaborate' with Excel and still use VBA. I have written some VBA that loads/updates data in a spreadsheet. The spreadsheet is saved in Google Drive so it can be accessed on the net. I need to effectively collaborate using an app called AppSheet that enables me to also edit/update the same spreadsheet. The problem is I keep losing data without warning.
For example this afternoon the spreadsheet was updated half a dozen times, one row at a time, over a two hour period. When I got home I looked at the spreadsheet on my PC and all the records were correctly displayed. 10 minutes later I reopened the spreadsheet on the same PC and somehow it had lost all of those updates. Fortunately Appsheet sends me an email every time it updates a record so I was able to re-enter the updates but it means the update process is unreliable and the repairs are time consuming.
I have raised a separate question on EE to see if I can work out how to use VBA to update a Google Sheet as that would fix the problem because it is saved direct to the cloud file. However I am also looking for an alternative solution using Excel, since I am more familiar with it. Is there any way of getting VBA to update the cloud version of a spreadsheet instead of updating the PC based copy then trying to sync which seems to cause the problem?