hey everyone,
i'm going to be as clear as i can about my problem.
http://www.rapaport.com/rapnet/prices/data/Weekly/round.pdf
this is the link, if you click it, you can see, that the site will ask you
for a username and password.
Now i want to make in vb a button that opens the link, fills in the user
name and password and get's the file.
i got this, but i don't have the slightest idea how to fill in the fields.
Dim oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True
oIE.Navigate
("http://www.rapaport.com/rapnet/prices/data/Weekly/round.pdf")
While oIE.Busy : End While ' wait for page to load...
'oIE.Document.Forms("form1").All("submit1").Click()
it all works fine until i open the site and that it keeps busy.
is there any way to fill in the fields?
many thx in advance
andy van steenbergen
Jeff Johnson [MVP: VB] - 30 Aug 2004 19:48 GMT
> i'm going to be as clear as i can about my problem.
> http://www.rapaport.com/rapnet/prices/data/Weekly/round.pdf
> this is the link, if you click it, you can see, that the site will ask you
> for a username and password.
> Now i want to make in vb a button that opens the link, fills in the user
> name and password and get's the file.
I recommend using the WinHttpRequest object available in the library
"Microsoft WinHTTP Services, version 5.1." I would assume that using the
SetCrendentials method will be what you need to specify user name and
password. I've never used this particular method myself.
Magicman - 31 Aug 2004 12:58 GMT
many thx, atleast i'm a bit further than before :-)
many thx again
Jeff Johnson [MVP: VB] - 31 Aug 2004 14:26 GMT
> many thx, atleast i'm a bit further than before :-)
> many thx again
Let us know if you get it working, for posterity.