Search code examples
vbaauthenticationonedriveusing

sign-in and authentication OneDrive using VBA


I need an example of the following (OneDrive authentication and sign-in) using VBA languge will used in Microsoft Access2013 File -or Microsoft access 2016 file


Solution

  • I think you are going to really struggle to achieve this from VBA. You would need to use a XmlHttpRequest library to make the HTTP calls to do the OAuth2 login flow. That's not going to be easy.

    What you might be easier is to create a VB.NET or C# application that calls OneDrive and then using an ODBC/OLEDB provider to write to the Access file. It just depends what you are trying to do whether this would be a suitable approach.