i have an excel sheet which pulls figures in from 2 seperate sources and i
use it to calculate differences etc..

one source its pulling from is an excel sheet that is named by todays date.
i.e pvbp_07_11_07.xls is the one for today.

if in my sheet i want my cells to update automatically with todays figures
and then tomorrow with tomorrows how do i refernce the cell to change daily
with the change in the name of the other sheet??
--
chesty