changing a function script

  • Thread starter GenerallyConfused
  • Start date
G

GenerallyConfused

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.
 
S

sebastienm

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
 
Top