code needed

[peter007]

Hi All,I am trying to write a code to scrape web data which currently is done manually every hour. Basically once logged on the web site I need to make some selections and enter the date and time range . The format is as follows 2014-09-03 13:00 and end time as 2014-09-03 14:00 and then click on search button.I need to do this automatically every hour i need to login to the website and then enter the previous time range and extract the datacan some one help me with automatically entering the time date and time range

 

[peter007]

can anyone help me on this please ?

 

[hateme28]

this should help get you started. but you'll probably need to do some research. in the provided example it will open internet explorer and navigate to google.

Sub example()
Dim ie As Object
Set ie = New InternetExplorerMedium
ie.Visible = True
ie.navigate "[URL]https://google.com[/URL]"
While ie.Busy
DoEvents
Wend
End Sub