| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding and Hyperlinking to a file
I want to search all subfolders in a given directory to see if there exists
an excel wb whose name begins with the contents of a specified cell. If it does, then I would like to hyperlink the specified cell to that file... else nothing i.e. StoreNum = Range("A1") <--- Criteria ?????????????????????????? ActiveSheet.Hyperlinks.Add Anchor:=Range("A1"), Address:= _ "S:\Special Orders\...\" & StoreNum & "*.xls" I hope that makes sense to someone. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HYPERLINKING PDF FILES HAVING NAMES IN COLUM TO A PDF FILE IN A FO | Excel Discussion (Misc queries) | |||
| Hyperlinking to another worksheet in existing file | Excel Discussion (Misc queries) | |||
| finding a file | Excel Discussion (Misc queries) | |||
| hyperlinking from excel to a point within a MP3 file | Excel Discussion (Misc queries) | |||
| Can't open a png file when hyperlinking through Excel. How to do? | Excel Worksheet Functions | |||
Linear Mode
