Wondering if it is possible to download files from a web facing sharepoint site using VBA. The files (so far testing with small (30kb) png images) are in a library which requires a password. Needs to work with Windows Security. My test website is an Azure Sharepoint Farm.
I've tried using:
URLDownloadToFile - ok for regular website, but can't manage to connect to the access restricted website
Object (InterenetExplorer.Application) - can open the site, can see the image, but unable to download
CreateObject("WinHTTP.WinHTTPrequest.5.1") - does not seem to retrieve the image
I'd like to do this in VBA but concede that I might have to look at VB.Net, in which case I will need a lot more help ;-)