Search for file on different subfolders

[Iraokusaicaro]

Hello,

I have a list of subfolders ranging from A10 to A1000.

All the subfolder (A10 to A1000) have a different name. All subfolders (A10 to A1000) must have a file named ABC.pdf.
Basically what I intend is:
If the file named ABC.pdf exists inside the subfolder that is in cell A10 then cell B10 returns me the full name of the file (ABC.pdf) and in cell C3 the link to the file.
This same procedure has to run from the A10 to the A1000.


Thanks

[CK76]

Did you mean cell C10?
Though I don't see point in separating B10 from C10.

Try something like...

Please Login or Register  to view this content.

[Iraokusaicaro]

Thanks for the help,

Just one more thing, I was trying to change the strFile, instead of being a fixed name, its possible to be a random name?

Because on different folders the file its different ABC1, other ABC2 etc..

I tried this for he serch for ABC and .PDF
strFile = "ABC*.pdf"

all the files begin with ABC and always .pdf

[CK76]

Sure something like...

Please Login or Register  to view this content.

[ProfMonteiro]

This code is very useful for me too.
I was thinking of something similar.
One question.
In this Code, how can i add the creation date and the date of modification of the PDF file?
Thanks.

[CK76]

Hi, please refer to Forum rule.

4. Do not post a new help request in an existing thread. (B)

Please start a new thread for your own question. Referencing this thread via hyperlink if necessary.

[ProfMonteiro]

Sorry all menbers of the Forum

[Iraokusaicaro]

thank you so much for the help!

[CK76]

You are welcome

If this solved your issue, please mark the thread as solved by using Thread tools found at top of your initial post.