I had a requirement :
There are some column values in excel sheet containing some date columns and
other data running from around 6 months.But the requirement is to retrieve
the whole set of column values or data which lies within the present week,ie,
if its today then i need to get all the data from 26th july to till date -
the present date must be taken from the system date. And there is one more
constraint ,the date column values are in the form of 'dd month-name yyyy'
eg:'15 march 2006'.Am in urgent need of the script, as am newbie to vb