Forum Discussion

Copper Contributor

Mar 01, 2019

Can I use VBA to update my on-line spreadsheet and bypass constantly failing sync?

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 accoun...

Copper Contributor

Mar 02, 2019

Thanks for the suggestion. That may work but it doesn't solve my problem.

In my case the VBA processes orders. So it either add records to the spreadsheet so the other user can process, or it updates records such as when an existing order is called up for delivery. I can receive as many as 40 orders during a business day. The other user (using AppSheet) updates those records as each order is processed. That means as many as 25 updates per day.

Unless I don't understand your suggestion correctly, it sounds like your idea of having them on different sheets would mean the process loses its integration.

JKPieterse

Silver Contributor

Mar 02, 2019

Hmm. This problem calls for a database solution if you ask me.

Rob4077
Copper Contributor
Mar 03, 2019
Yeah, that's what I was afraid of. Unfortunately I can't justify the expense, and my expertise is limited to moderate VBA. Looks like I may need to dump Microsoft, learn Google Script, and re-write the VBA in Google Script, since that updates direct to cloud and avoids sync issues.
- JKPieterse
  Silver Contributor
  Mar 03, 2019
  I've heard MSFT are working on improving the syncing, which is soon to be released.
  - Rob4077
    Copper Contributor
    Mar 05, 2019
    I hope it's soon! I only do about 40 - 50 jobs a week and it's painful having to keep manually fixing