Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find links to other worksheets using VBScript?
Hello,
I have a quandry, I am moving excel files between servers and would like to impact assess the links in excel spreadsheet to other workbooks. The links have for instance <drive letter:\folder name\[test.xls]Sheet1'!$A$1, if the drive letter changed i would like to have some code which i can run against the file which will update the links to point to the correct location. But i also need some script which will display the link and whats it's point to. anyone done this before? Thanks -- The AD Designer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links between worksheets and more... | Excel Worksheet Functions | |||
Worksheets.add in VBScript overwrites existing worksheet | Excel Worksheet Functions | |||
How do I Find links in worksheets - not in any formula | Excel Worksheet Functions | |||
Links to other worksheets | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |