search

VBA-tools / VBA-Web

VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
http://vba-tools.github.io/VBA-Web/
MIT License
2.01k stars 494 forks source link

Proxy setting don't appear to be respected #145

Closed zippy1981 closed 9 years ago

zippy1981 commented 9 years ago

I'm setting a proxy on the webclient (http://localhost:8888 which is foddler.exe), and it doesnt seem to be respected. I'll troubleshoot.

I'm also going to try to autodetect the proxy settings from Wininet .

bdr99 commented 9 years ago

Did you set Client.EnableAutoProxy = True for your client?

timhall commented 9 years ago

I've had some issues with Fiddler in the past (don't have it installed at the moment to test):

  1. Fiddler doesn't capture localhost traffic (I'm not sure if this applies to your case, but it was my issue): http://docs.telerik.com/fiddler/Observe-Traffic/Troubleshooting/NoTrafficToLocalhost
  2. It should work directly with Client.ProxyServer = "...", but an alternative is to follow these instructions, http://docs.telerik.com/fiddler/Configure-Fiddler/Tasks/ConfigureWinHTTPApp, and then use Client.EnableAutoProxy = True as suggested above
  3. I'm not sure if it matters (I realize localhost = 127.0.0.1), but all of the docs I've seen use the following url: Client.ProxyServer = "127.0.0.1:8888"
  4. Setting the proxy should be logged, so you can use WebHelpers.EnableLogging = True and the Immediate Window (ctrl+g) to make sure it's being set and that the requests/responses are occurring

Closing this issue for now, but please feel free to re-open with more details if it's still not working.