View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default web query w/login and password

Hi,

Please provide the URL (address) for the web page, and we may be able to
help out further. The process really depends on how the page is set up.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Fun Kid wrote:
No, it is not a popup login dialog. The boxes for login and password
information is contained in the web page.

I'm happy to know that there is a way to do this. Thnx.

"Jake Marx" wrote in message
...
Hi Fun Kid,

What is the URL for the login page? Is it a popup login dialog, or
do the textboxes reside on the web page itself?

There are ways to do this, but they aren't terribly straightforward.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Fun Kid wrote:
I would like to extract information from a my 401k website on a
regular basis and I intend to use an excel web query to do that. But
the website requires a user id and a password in order to access the
information. How can I do this?

Eventually, I would like to set up a macro using VBA for excel so
that each time I open the file, it will provide the website with
the user id and login, extract the data and plot the daily balance.

Any suggestions would be appreciated.