Web Query authentication

[lear]

Hello all,

I'm currently trying to get a web query to work, but it requires
authentication first.

When I set up the web query, I enter the URL with username and
password as parameters in it. After it logs in, it redirects and this
redirected URL is what the web query uses. So when I want to refresh,
it says it can't find the URL because I have not authenticated. Is
there a way to authenticate first and keep that state while the query
runs with the redirected URL? I tried putting this into VBS and used
the authenticating URL via IE, but it looks like Excel authenticates
differently and doesn't use the browser.

I've tried the .POSTTEXT option, but since the URL when logging in is
different than what the web query uses that's not working.

Here is the authenticating URL:
https://www.google.com/accounts/Ser...://adwords.google.com/select/gaiaauth&followu

Here is the redirected URL that the web query uses:
https://adwords.google.com/select/CampaignSummary

Thanks in advance!