Hi everyone,

I need to update every month file references in a master file. The
reference files are updated every month with production data and stored
in a different folder on a P drive. The folders have the same structure
that differs only with the name of the month, so basically I have the
following P:\monthly_reporting\2006\1_January\master_product ion.xls,
and in February the updated reference files will be in
P:\monthly_reporting\2006\2_February\master_produc tion.xls

These links need to be updated every month. Is there a way to construct
a macro to do that (for the moment, we are updating the references
manually with edit/links.)? I am using excel 2003.

Thank you!!


--
LostInSpace
------------------------------------------------------------------------
LostInSpace's Profile: http://www.excelforum.com/member.php...o&userid=32771
View this thread: http://www.excelforum.com/showthread...hreadid=526032