How to Add a function to web file Name
 

I am downloading a file daily from net.In order to automise this task I wrote
a code in my workbook.But filename is changes daily with current date.how to
add a funnction to the code of filename.I wrote
workbooks.Open Filename:= _
"http://www.nse-india.com/content/historical/EQUITIES/2005/DEC/cm02DEC2005bhav.csv"
in this address 2005/DEC both changes on change of year and month and
02DEC2005 changes daily.how to incorporate this change of filename daily in
my code