changing a function script

[Guest]

I need to run a macro that searches a range (column) that contains references
to another spread sheet in the function line e.g.,

='I:\REPORTS\Fairfield\[c_090204.xls]Route1'!$G14
The 090204 is yesterday's date.

I need to replace 090204 with 090304 (being today's date) in the reference
in all cells within the search range.

Can this be done automatically without prompting the user to enter the
values?
I have not been able to figure it out.

 

[Guest]

Hi,
Menu Edit > Links, do a Chnage Source.

Regards,
Sébastien

 

[Guest]

also, programmatically, if really needed:
ActiveWorkbook.ChangeLink Name:="I:\REPORTS\Fairfield\c_090204.xls", _
NewName:= "I:\REPORTS\Fairfield\c_090304.xls", _
Type:= xlExcelLinks

Regards,
Sebastien

 

[Guest]

Thanks again, I'll let you know after I test it tomorrow.

Jimmy