Ok, I did it. Here the code: Sub SaveFileFromURL() Dim FileNum As Long Dim FileData() As Byte Dim WHTTP As Object mainUrl = “https://www.website.com/” fileUrl = “https://www.website.com/dir1/dir2/file.xls” filePath = “C:\myfile.xls” myuser = “username” mypass = “password” ‘@David Zemens, I got this by examining webpage code using Chrome, thanks! strAuthenticate = “start-url=%2F&user=” & myuser & “&password=” … Read more
Merely opening the ofstream in binary mode does not change the way that the << operators work – they will always perfform formatted output. You need to use the stream’s write() function, which does unformatted output.
Create / Purchase certificate. Make sure it has a private key. Import the certificate into the “Local Computer” account. Best to use Certificates MMC. Make sure to check “Allow private key to be exported” Based upon which, IIS 7.5 Application Pool’s identity use one of the following. IIS 7.5 Website is running under ApplicationPoolIdentity. Open … Read more