I am behind a firewall and have to login through a proxy using MSXML. I only have access to MSXML 2.0 and MSXML 3.0 from VBA for Excel 97. How can I make this work?
If you are implementing client-to-server HTTP access using MSXML, you may use XMLHTTP class (which uses WinInet
and hence will take the proxy settings from Internet Explorer settings).
If you are doing server-to-server HTTP communication, the best option would be to use MSXML 3.0 (or higher) and use
ServerXMLHTTP (which uses WinHTTP, a HTTP protocol stack designed for server safe HTTP access).
Remeber that ServerXMLHTTP is not available on all platforms (like on Windows 98 and Windows Me).
For ServerXMLHTTP to work, you might have to use ProxyCfg utility.
To load an XML document from a server that is located behind a firewall, with the ServerHTTPRequest property set to True , you must first run the WinHTTP Proxy Configuration Utility (Proxycfg.exe). However, if the XML document is loaded from a server that is not behind a firewall, you should not need to first run Proxycfg.exe, even if you only use the proxycfg -d command.