Hi All,
I have an interesting challenge. I've created a workbook that is able to check one's desktop for the most up-to-date version of certain workbooks (based upon file names), and import data from the worksheets within those workbooks (simple copy and paste).
Instead of searching one's desktop for files to import, I was wondering if it was possible to search for and import these files from a SharePoint. If this wasn't difficult enough, the SharePoint in question is password-pin protected, meaning that when navigating to the site, a Windows Security pop up asks for a pin to access the SharePoint.
Thanks in advance, everyone!
Best,
Chris
Bookmarks