Interacting with web page
 

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


--
gunny1979
------------------------------------------------------------------------
gunny1979's Profile: http://www.excelforum.com/member.php...o&userid=32932
View this thread: http://www.excelforum.com/showthread...hreadid=528755

Interacting with web page
 

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

--
renega
-----------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...fo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=52875

Interacting with web page
 

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?

--
gunny197
-----------------------------------------------------------------------
gunny1979's Profile: http://www.excelforum.com/member.php...fo&userid=3293
View this thread: http://www.excelforum.com/showthread.php?threadid=52875