| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Check if all formula's in a column are linked to the same file/folder
Hi,
I have a large workbook with a lot of links to different files (with same layout). I am looking for a way to check if the formula's in a column are all linked to the same file or folder. Folder would actually suit better because the filename stays the same. Example: C:\forecast2008\details.xls C:\forecast2009\details.xls Column C in workbook "summary.xls" sheet1 links to .... 2008\details.xls Colums D links to ....2009\details Can't find a way to use the text of the formula for comparisons. Cheers, Harold |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check Folder For Files | Excel Discussion (Misc queries) | |||
| Check if a folder has x files in it. | Excel Discussion (Misc queries) | |||
| How to check if a file exists in an ftp folder | Excel Discussion (Misc queries) | |||
| Save copy of folder with linked files | Excel Worksheet Functions | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
Threaded Mode
