Interacting with web page

[gunny1979]

Hi,

I need to interact with a web page to select certain dates then import
the data into excel!!
Does anyone have a code for this??

Kevin Gunn

 

[renegan]

ActiveSheet.QueryTables.Add(Connection:= _
"URL;YOUR URL GOES HERE", Destination:=YOUR RANGE GOES HERE TO_ IMPOR
THE DATA)

You can refresh the data with this when you need to:

Range("RANGE YOU USED ABOVE TO IMPOT DATA").Select
Selection.QueryTable.Refres

 

[gunny1979]

Hi thanks for this, but i dont think I was clear in what I was after,
I have a lnk to a website that I need to put 2 sets of dates in to tak
me to the page i need to export the data from.

Any ideas?