Author Topic: Connect to SharePoint Online excel workbook  (Read 149 times)

0 Members and 1 Guest are viewing this topic.

ITWorkingSolutions

  • Newbie
  • *
  • Posts: 3
Connect to SharePoint Online excel workbook
« on: September 08, 2020, 04:47:27 AM »
Hey guy's, I have a humble VBA solution for updating the underlying excel workbook that acts as the external data source. Needs more refinement, and maybe convert to add-in. Nothing to compare with Nikolay Belykh's BackSynch add-in, but achieves the basics. This I share that it may help others (see attachment). Sorry I have not commented for sharing, and... it's basic. The problem I face is linking to a workbook located in SharePoint Online. Can't find how to read and write to an excel workbook located in SharePoint Online using ADO or other data connection mechanism. Note not interested in linking to SharePoint list. Thank you for any pointers you can provide.

Nikolay

  • Hero Member
  • *****
  • Posts: 958
    • UnmanagedVisio
Re: Connect to SharePoint Online excel workbook
« Reply #1 on: September 08, 2020, 05:12:24 AM »
Looks like you have checked out my BackSync tool  :)
Just wondering, why didn't it work in your case (so that I could improve)?
In principle, it should work with share point list as well.

ITWorkingSolutions

  • Newbie
  • *
  • Posts: 3
Re: Connect to SharePoint Online excel workbook
« Reply #2 on: September 09, 2020, 05:33:52 AM »
No problem with your add-in the issue is I need to update an excel workbook saved in SharePoint Online. That's where I'm stuck. ADO doesn't want to play, and I'm not sure if a) it can't done; b) authentication issue; c) should be using another provider.

Nikolay

  • Hero Member
  • *****
  • Posts: 958
    • UnmanagedVisio
Re: Connect to SharePoint Online excel workbook
« Reply #3 on: September 09, 2020, 06:02:00 AM »
Thank you for the response! I see.
So you want to synchronize data not with a SharePoint LIST but with an excel FILE stored in a SharePoint document library, right.

ITWorkingSolutions

  • Newbie
  • *
  • Posts: 3
Re: Connect to SharePoint Online excel workbook
« Reply #4 on: September 09, 2020, 06:19:10 AM »
Yep that's the sum of it.