Manipulate objects on web page in VPScript 1

[JohnAlderman]

I have a web page I log into every week, authenticate and then download 3 (Excel) files. This manual procedure takes 27 descrete steps.
I would like to write a VBScript application that does this unattended.

What I cannot seem to figure is how VBScript can read text boxes, labels and other controls on the web page, and then 'click' pushbuttons and select text objects.

I know that HTML has ways to address these objects, but I don't know what they are.

My platform is Vista/Win7, with IE8. I have VBSEdit, Power
Shell, and even Jscript available.

This has got to be easy and everybody else knows how to do it, but I am stuck!.
John Alderman

 

[guitarzan]

Something like this, to get you started:

Option Explicit
Dim objIE, sTextboxValue
Set objIE = CreateObject("InternetExplorer.Application")
	objIE.Visible = True
	objIE.Navigate "[URL unfurl="true"]http://www.mysite.com"[/URL]
	Do While objIE.Busy
		WScript.Sleep 500
	Loop
	sTextboxValue = objIE.Document.getElementByID("sometextboxname").Value
	objIE.Document.getElementByID("somebuttonname").Click
End With

The code above will open a web page, and then store the contents of a text box whose ID is "sometextboxname". (You need to examine the HTML of the page you are navigating to, to find out the ID or Name of the text box you want to retrieve data from)
Similary, this is how you can "click" a button.