ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Finding and Hyperlinking to a file (https://www.excelbanter.com/excel-programming/329667-finding-hyperlinking-file.html)

Mike

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.


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com