There is folder "Doc" at C:\ that has 5 files say: File 1 File 2 File 3 Other 1 Other 2 where File 1,2 and Other 2 is pdf and remaining is msg. The formula below can hyperlink to folder "Doc": =HYPERLINK("C:\Doc","File") How to modify the formula to show folder with file having specified word "File" only? (Same result as search word "File" at folder "Doc")

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

How to hyperlink to folder showing files with specified word only?

Thread starter London12F
Start date Oct 20, 2017
Tags

doc file folder formula word

London12F

Board Regular

Oct 20, 2017

[TABLE="width: 524"]
<colgroup><col></colgroup><tbody>[TR]
[TD]There is folder "Doc" at C:\ that has 5 files say:[/TD]
[/TR]
[TR]
[TD]File 1[/TD]
[/TR]
[TR]
[TD]File 2[/TD]
[/TR]
[TR]
[TD]File 3[/TD]
[/TR]
[TR]
[TD]Other 1[/TD]
[/TR]
[TR]
[TD]Other 2[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]where File 1,2 and Other 2 is pdf and remaining is msg.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The formula below can hyperlink to folder "Doc":[/TD]
[/TR]
[TR]
[TD]=HYPERLINK("C:\Doc","File")[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]How to modify the formula to show folder with file having specified word "File" only?[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 524"]
<tbody>[TR]
[TD](Same result as search word "File" at folder "Doc")[/TD]
[/TR]
</tbody>[/TABLE]