Excel VBA Office 365 connection issue with localhost on IISExpress

[abp16]

Any pointer to connect a localhost service hosted on IISExpress with windows authentication from Office 365 VBA?
Successfully tested example will a be great help where Authorization of Msxml2 Request is being set.

 

[Kyle123]

Use the winhttp library not the msxml, it has windows authentication baked in. Note the SetAutoLogonPolicy line in the example here: https://stackoverflow.com/questions/31574693/open-web-page-from-vb-script-using-windows-auth