Web Query using Excel 2000

[JDoggity]

Is there a way to query a web site that is password protected?

I'm on a Intranet and I want query a site on the same Intranet. I have my user name and login.

Would I be able to use VBA that can automaticaly login and then query the data I need?

Thank in advance.

 

[Juan Pablo González]

I'm not completely sure of this, but I *think* that it should work pretty similar to the way an FTP site works ?

http://username:password@ftp.thesite.com

http://www.cs.rutgers.edu/~watrous/user-pass-url.html

 

[mForteed]

Is there another way? I also have the "@" symbol in my login ... does this present another problem? And btw, when you go to the secured site, preceding the URL is "https://". How does that differ from the regular "http://" when one is trying to login to get a web query to update? It also seems that Excel doesn't recognize the cookies after you have logged in through IE, because I am still getting the "web query returned no data" error message after logging in manually and through script (see below). Thank you for your help.

Sub LoginMe()

Dim appIE As Variant

Set appIE = CreateObject("InternetExplorer.Application")

appIE.Visible = True

While appIE.busy
DoEvents
Wend

appIE.navigate "https://www.hedgefundresearch.com/mon_register/index.php?fuse=login&1098991088"

Application.Wait Now + TimeValue("00:00:05")

AppActivate "HFRI Monthly Indices - Login"


SendKeys "{TAB 33}", True
SendKeys "superstar@excel.com", True
SendKeys "{TAB}", True
SendKeys "holla", True
SendKeys "{ENTER}", True

End Sub

 

[NateO]

mForteed,

Please continue your discussion in a single thread:

http://www.mrexcel.com/board2/viewtopic.php?t=112586