search for file, if exist, mark cell and create link

[elmoinstyle]

hi!

i would like to ask someone to help me program macro. i have only beginner knowledge about programming in excel.

i have excel file, i attached it.

this is how looks my directory:

screen.png

in excel is column D, which contains details name, in folder DETAILS is *.pdf file with same name, for example DSB-100.pdf.

i would like to check is file exist, then mark cell N in green and create link to this file if not, then mark cell red.

of course it should work like, if checking data in D3 then mark N3, if checking data in D4 then mark N4 and so on.

i hope that commented clear enough.

thanks in advance.

[Naveed Raza]

Hi

i will get back to you soon

[elmoinstyle]

will someone help?!

[xlbiznes]

try this code :

Please Login or Register  to view this content.

[elmoinstyle]

try this code :

Please Login or Register  to view this content.

thanks! it works, but i modify little bit!

can you help little more - how to set search in subfolders to?!

i have folder DETAILS, and in this folder is two more folders, PLATE and PROFILES.

so DETAILS folder is main, but there is two subfolders.

can you please help twitch your code modified by me!?

Please Login or Register  to view this content.

[xlbiznes]

firstly , Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).
The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:

Select Code copy to clipboard
your code here ...
and here ...
and here
You can also type the code tags in manually if you prefer.

[elmoinstyle]

firstly , Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
Highlight your code and click the [#] button at the top of the post window (if you are editing an existing post, press Go Advanced to see the [#] button).
The result will appear like this in the post window:

Please Login or Register  to view this content.

... and appear like this when posted:

Select Code copy to clipboard
your code here ...
and here ...
and here
You can also type the code tags in manually if you prefer.

sorry! correct my mistake.

what about search in sub-folders?!

[xlbiznes]

here you go,

Please Login or Register  to view this content.

[elmoinstyle]

here you go,

Please Login or Register  to view this content.

thanks!!!!

[xlbiznes]

If your problem is solved, please say so clearly, and mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Dropdown option or Edit button will not appear -- ask a moderator to mark it.