How to Download File from Password Protected SharePoint using VBA (CAC Login)?

Experts,

I'm in the process of writing a couple of VBA scripts that will enable the user to download an Excel file from our password protected SharePoint site and import the data into the active workbook. I work for a government office, and our SharePoint site required a CAC login (CAC card must be inserted into computer). Upon navigating to the site, the Windows Security box pops up and requires a pin #. This workbook will be distributed to a couple of my co-workers.

I'd really prefer to not use SendKeys for obvious reasons. Is there any other way to do this?

I've accomplished this a number of times on non-government SharePoints, but am having some issues due to the CAC login. Any ideas?

Question asked on following forums:
https://stackoverflow.com/questions/...-vba-cac-login
https://www.mrexcel.com/forum/excel-...cac-login.html



Best,
Chris