Two Factor Authenitfication using VBA in Excel to Download Attachments using a URL

[Arty Choke]

PROBLEM STATEMENT:
I am unable to open file attachments via a URL using VBA. Instead of getting the file, I am asked to log in.


DETAILS:

• This was working a couple of months ago.

• The URL's seem to be OK.

• The URLs are like this:

http://wiki.intra.mycompany.com/download/attachments/232030890/DataFile001.xlsx​

• If I click on the URL, a web browser opens and the typical download process begins, starting with, "What do you want to do with this file?". I click 'SAVE', and it saves. No additional logins required, and I get the workbook I asked for.

• When executed via VBA, instead of getting my Excel file, I get an Excel file with one worksheet that contains a garbled log in screen.

• The VBA code is:

Set source_report = Workbooks.Open(cell.Value)<strike></strike>​

​

I suspect that this has to do with two factor authentication, which my company has been using more and more. Like I said, this used to work.

The files I am trying to download are coming from our Wiki that lives in Atlassian's Confluence Server. I am logged in to Confluence Server. I checked.<strike></strike>



Help?
Arty

 

[Arty Choke]

bump