There are files (pdf or msg) at folder "C:\Users": AAA-1 (pdf) AAA-2 (pdf) AAA-3 (msg) BBB-1 (pdf) BBB-2 (pdf) How to set the formula in excel to hyperlink to folder "C:\Users" showing files with word "AAA" only? i.e. files AAA-1, AAA-2, AAA-3 only

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 with specified word?

Thread starter London12F
Start date Nov 14, 2017
Tags

aaa-3 files folder msg pdf

London12F

Board Regular

Nov 14, 2017

[TABLE="width: 609"]
<colgroup><col></colgroup><tbody>[TR]
[TD]There are files (pdf or msg) at folder "C:\Users":[/TD]
[/TR]
[TR]
[TD]AAA-1 (pdf)[/TD]
[/TR]
[TR]
[TD]AAA-2 (pdf)[/TD]
[/TR]
[TR]
[TD]AAA-3 (msg)[/TD]
[/TR]
[TR]
[TD]BBB-1 (pdf)[/TD]
[/TR]
[TR]
[TD]BBB-2 (pdf)[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]How to set the formula in excel to hyperlink to folder "C:\Users" showing files with word "AAA" only?[/TD]
[/TR]
</tbody>[/TABLE]
i.e. files AAA-1, AAA-2, AAA-3 only