find directory

[max_max]

Hello everyone.
I ask for help to do this:

I have a path (path) fixed in A2
in B2 the name of a directory
in C2 the name of a file to search

I click in a "SEARCH" button
in B3 if the folder is present it must be displayed present, is not present displayed non present
in C3 if the file is present it must be displayed present, is not present displayed non present

I hope I explained myself.
max_max

[Sintek]

in B2 the name of a directory

Do you mean folder...
Is the file of C2 in the folder of B2 or not

[max_max]

C2 = folder
B2 = file in folder B2

[Arkadi]

max_max:

The directory in "B2"... does it mean the folder should be "C:\Users\massimo\Desktop\moduli_salvati\massimo" or does the search need to check all folders in "C:\Users\massimo\Desktop\moduli_salvati" because maybe "massimo" is a folder inside ANOTHER folder in the fixed path? (for example "C:\Users\massimo\Desktop\moduli_salvati\blabla\pieces\massimo")

[Sintek]

this does not makes sense...

C2 = folder
B2 = file in folder B2

And ...

If the file |C2 was in the folder B2 and the folder was not there then both would be "not present"


Perhaps...

Please Login or Register  to view this content.

[Arkadi]

Here is a possibility:

Please Login or Register  to view this content.

[max_max]

Thanks sintek, arkadi
To be sure I have to find the your macro tomorrow in the office.
Thanks in advance.
max

[max_max]

Thanks sintek, arkadi
to your macros tried this morning in my office work.
Greetings and thanks.
max_max

[Sintek]

pls mark thread as solved... tx for rep +