Forum Discussion

Rob4077's avatar
Rob4077
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...
excel
Excel Online
Macros and VBA
office 365
JKPieterse's avatar
JKPieterse
Silver Contributor
Mar 01, 2019
I'd expect things would work if you would each update a different area (different table or sheet) of the file. That way you avoid most trouble I think.
  • Rob4077's avatar
    Rob4077
    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's avatar
      JKPieterse
      Silver Contributor
      Mar 02, 2019
      Hmm. This problem calls for a database solution if you ask me.
      • Rob4077's avatar
        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. 

Resources