I am having this same issue. Just started happening in the past month. It does NOT happen on my machine - but the exact line of VBA looks like this
returnValue = URLDownloadToFile(0, "https://mycompany.sharepoint.com/sites/MYSITE/myfolder/myfile.xltx" , strSavePath, 0, 0)
This is a site that is in trusted sites for the computer AND in trusted sites for MS Office and all its subdirectories (its in 2 areas of the registry). This is the only non-cheesy way to get stuff off of sharepoint . Sharepoint is our new network drives - we are at the mercy of so many other companies cooperating.
I AM A PEE-ON and have 0 ability to affect anything IT does. So what they say goes - and this isn't going away. Now I have to make a c# app to interface etc. etc. when this library is a perfect one already built into windows for this purpose.
Is there any way to get this fixed for trusted sites? I appreciate the protection but this has gone a little too far. Thoughts? ETA?
EndpointAgent (003) last part.txt