I have to fetch data from a file in SharePoint 2013 using VBA and I am mapping the SharePoint site to my network drive and accessing the file. This is working fine when I had already signed in with my Outlook email in to the SharePoint site. But if I am trying this without signing in, I get an error message something like "unable to complete the request because the user was not authenticated". So, I just want to know how can I authenticate myself and logon to SharePoint through VBA before I map the site to a network drive?
Any help would be appreciated.