| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup only a set of values. | Excel Worksheet Functions | |||
| Vlookup based on two lookup values | Excel Worksheet Functions | |||
| vlookup and filename returning same result on each sheet. | Excel Discussion (Misc queries) | |||
| Generate random numbers between two values and with a given mean | Excel Worksheet Functions | |||
| sum values between today and 6 months prior | Excel Worksheet Functions | |||
Threaded Mode
