| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic drive selection to update link
I have the below code live.. but can I have a code that search in drive F, G,
H if this path does not exist? That is it should search in "F:\Primary\Master-May.xls", _ "G:\Primary\Master-May.xls", _ "H:\Primary\Master-May.xls", _ Sub ref() ActiveWorkbook.UpdateLink Name:= _ "E:\Primary\Master-May.xls", _ Type:=xlExcelLinks End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| update all hyperlinks to another drive | Excel Programming | |||
| Import from MS Access - Lose the drive letter..link only to drive | Excel Programming | |||
| Link to Network Drive | Excel Discussion (Misc queries) | |||
| Link to Network Drive | New Users to Excel | |||
| Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Threaded Mode
