VBA - load color scheme from SharePoint

Hi guys

Hope someone can help me with an annoying problem

I have an excel file which is used by different companies who uses different ColorSchemes. I have buttons in the first tab, so they can chose the colors they want.
Previously I have had the different color schemes in a folder on a shared server and used the code:

Please Login or Register  to view this content.

We have now moved our template to a SharePoint, and I’m trying to open the ColorX.xml from here with the same command:

Please Login or Register  to view this content.

But It tells me it can’t access the file. If I paste the path into a browser, I have no problem accessing it.

If I use IE and go the color theme folder, and click on ColorX.xml, it asks me if I want to open the file as write-protected or editable?

Does anyone know why I can’t open the file through a macro, and even better does anyone know how I make it work?

Best
H

Thanks for your suggestion, just tried it, but same result

/H

If it is of any help, this is the message I get
ScreenHunter_132 Oct. 28 12.12.jpg