Up until recently, I had a couple of ways of accessing SharePoint folders. After our company's SharePoint update, some of those channels have been shut down.
Here's what I'm trying to do:
- On a worksheet in Excel, the user pushes a button tied to a macro.
Via the macro- The button color changes to yellow and text says "please wait".
- Info from named ranges on the worksheet are gathered and compiled to help derive the correct SharePoint folder address.
- A data table has contents/rows deleted.
- The SharePoint folder contents populate a VBA list.
- The list values populate the data table in a loop until all of the list items have been added (the data table is used as a named range to populate a dropdown data-validation-list field).
- The button color changes back to its original color, and text says "Click to run".
Previously my code worked great... . Now, it's broken. The only way people using this Excel tool can access the SharePoint is via their permissions (OneDrive login or Single Sign On via the Windows login) and connecting to an Intranet SharePoint Site via https.
I can use the https url in Windows Explorer to access the folder. But, my macro doesn't recognize the address via this:
aFileAddress = Dir("https://[my SharePoint-folder address]")
Bookmarks