Contents
Also SharePoint 2013 Online has a different authentication mechanism than On premise SharePoint 2010 which uses Windows Authentication. I am facing problem to connect to this SharePoint 2013 online site from VBA code (excel macro) and download a file from SharePoint document library to user’s machine. Thank you.
The user browser session needs to authenticated with SharePoint, if it’s not, then the web app has to redirect to the SharePoint OAuth endpoint for user authentication (username/password) This model is demonstrated by a provider-hosted SPO app created in Visual Studio
How does VBA work with SharePoint on azure?
Some of the cells point to the files to upload and others are metadata. This worked fine on premises with our own SharePoint, but my developers are saying that the VBA handle handle the Azure AD authentication employed by our SP O365 environment at Azure.
Can you use Azure AD authentication with SharePoint?
This worked fine on premises with our own SharePoint, but my developers are saying that the VBA handle handle the Azure AD authentication employed by our SP O365 environment at Azure.
Use the UNC path rather than HTTP. This code works: To get the UNC path to use, go into the folder in the document library, drop down the Actions menu and choose Open in Windows Explorer. Copy the path you see there and use that. Martin.
Solutions reviewed all involve linking an Excel table to SharePoint and publishing the content keeping the two versions in synch. Looking for a solution that does not involve synchronization between Excel and SharePoint.
Is there a way to connect to SharePoint Online?
Actually I wanted to connect to SharePoint 2013 online (Office 365). SOAP won’t go with the SharePoint 2013 version. Also SharePoint 2013 Online has a different authentication mechanism than On premise SharePoint 2010 which uses Windows Authentication.