Why not write Auto_Open code that redirects the link.
If it is the only link source for the workbook, you could use something
like this:
Sub Auto_Open()
ThisWorkbook.ChangeLink ThisWorkbook.LinkSources(1, xlExcelLinks), _
ThisWorkbook.Path & "\MyFile_" & Format(Date, "yyyymmmdd") & ".xls"
End Sub
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|