Sending strings to a webpage
 

Does anyone out there know how to take a string from excel, or a VBA
variable and insert it into a field on a web page? I am trying to log
into a web page automatically. I have even gone so far as to create my
own stupid web browser in VBA but am stumped as to how to do this.
Please help.

Sending strings to a webpage
 

schreef in bericht
ups.com...
Does anyone out there know how to take a string from excel, or a VBA
variable and insert it into a field on a web page? I am trying to log
into a web page automatically. I have even gone so far as to create my
own stupid web browser in VBA but am stumped as to how to do this.
Please help.


You need to know the name of their login script, and also the names of the
form fields. Check out their HTML source code for that. Then in VBA, the
code will be something like this:

ActiveWorkbook.FollowHyperlink
("http://www.test.com/login.php?UserID=Me&UserPw=MyPassword&submit")

I guess you can check out the correct link in the address bar of your
browser when logging in.