get external data
 

I have a peculiar problem. I am familiar with getting external data through
webquery
I want to download some CURRENT DATA of stocks from a webpage
I have a webpage the first link is something like let us call this "current
data" with address as
http://www.nseindia.com/bhavcopy/BhavHandler?segment=0
this link leads me to another link giving me a choice to download either in
csv or dbf fomat
If I click either of these I get the current data. I can copy this link
name in my newwebquery window against item1.
But this link has got a date embedded in the address for e.g as given below
http://www.nseindia.com/content/hist...m28MAY2004bhav
..csv
I understand why this had been done because the data of 28th May will go
into their archives which can be downloaded whenevaer anybody wants.
But I am interested only downloading the CURRENT data.
If I refresh data on 31st I will get only on 28th data and not 31st data.
I can copy the address of the first link given above in my webquery but on
clicking this webquery I will get only the
text as follows in my excel
----------------------------------------------------------------------------
--------
Home Equities Market Information Market Today Latest Bhavcopy

Latest Bhavcopy

Download file in csv format----------(my note:this and the following one
are web links in the webpage=here it is text)


Download file in dbf format
==================================================


. as this is only
a text in my excel I cannot click it to get the data
any solutions to do this by vba or have I to everyday manually do
getexternaldata and click the correct link.
I have explained to some detail to be celar to me.
thanks.