Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit links
Hi,
I would like to have the Links (edit links) update to point to the appropriate desktop location where the options sheet (the .xls file with all the drop downs) is located. Each users desktop path name is different. changed the linked file location (i thought)???: ActiveWorkbook.ChangeLink Name:="C:\Option.xls", NewName:=sPathDeskTop & "\Option.xls", Type:=xlExcelLinks opens the options file: Workbooks.Open Filename:= sPathDeskTop & "\DatVal.xls" Problem: In the Edit|Links menu the location is still "C:\" and the drop downs don't work. -- Thank you, vbcraft |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit links
sorry (Datval.xls ...should be Options)
opens the options file: Workbooks.Open Filename:= sPathDeskTop & "\Options.xls" Please help if you can!!! -- Thank you, vbcraft "vbcraft" wrote: Hi, I would like to have the Links (edit links) update to point to the appropriate desktop location where the options sheet (the .xls file with all the drop downs) is located. Each users desktop path name is different. changed the linked file location (i thought)???: ActiveWorkbook.ChangeLink Name:="C:\Option.xls", NewName:=sPathDeskTop & "\Option.xls", Type:=xlExcelLinks opens the options file: Workbooks.Open Filename:= sPathDeskTop & "\DatVal.xls" Problem: In the Edit|Links menu the location is still "C:\" and the drop downs don't work. -- Thank you, vbcraft |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
edit links | Excel Worksheet Functions | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
VBA to edit links | Excel Discussion (Misc queries) | |||
edit links | Excel Worksheet Functions |