I'm using the MSXML object in some VBA code to retrieve data and load it into Excel 97. Excel is being run form within IE5 by redirecting to https://hostname/aa/bbb/file1.xls
The source of the data being called by the Excel VBA code is on a secure server so I need the call to be authenticated. The web server is not an IIS server.
The code used is bascially:
Set LoadXML = CreateObject("MSXML.DOMDoc
LoadXML.async = False
The Load method is failing because it is either trying to parse the authentication screen or if I use a modal dialog login then it fails with Access is Denied.
The user will already have authenticated on the server to get to that point. So why is the MSXML object not using the users current IE5 authenticated session ?
No each call is going to be unique. I cannot use a call similar to setProxyCredentials() as I won't know a specific username and password - these should come form the IE5 session.
Any ideas ?