LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default webquery with login first

Hi,
I need to access a table of financial quotes on yahoo finance. it has a
table format that is only available to members (if you type in its URL
while not logged in you get a format without the fields i want). so i
first created the code to login and that works fine. then i had the
code for the webquery. the problem is that the webquery tries to access
the webpage without using the open connection, that has logged in. so
the webquery's connection hasn't logged in, and has no access to the
table in the format i want.

I am trying to avoid the solution of being automatically logged in to
yahoo and just using the webquery itself.

Can anyone tell me how the webquery can open the desired page from the
open connection that is logged in? or how to login with the webquery
itself, and then navigate to the page i want and download the table in
the format i want?

thank you very much for your help,

Ian

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Webquery Neale Excel Worksheet Functions 3 August 25th 08 05:26 PM
Problem with webquery in VBA Wilco[_2_] Excel Programming 1 January 9th 05 01:48 AM
Webquery Othello Excel Discussion (Misc queries) 0 December 1st 04 12:41 PM
How to disconnect when WebQuery done Nathan Gutman Excel Programming 4 December 24th 03 03:31 PM
Using Webquery via VBA Richard Winston Excel Programming 3 December 2nd 03 12:50 PM


All times are GMT +1. The time now is 10:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"