VBA to search for value in all sheets of other workbook

[esukei]

Hello everyone

I have two files.
1. Workfile (where the macro will be stored)
2. Valuefile

I want to search for the value in C16 of the workfile in column D in all sheets of the valuefile.
If found copy the value of column O of the found row to the workfile (column G).

How can I achieve this?
Thanks in advance for your help.

[Kaper]

Try:

Please Login or Register  to view this content.

[jindon]

For the files uploaded.

Please Login or Register  to view this content.

[esukei]

Thank you for your code.
Unfortunately the sheets are not called "Sheet 1" or "Sheet 2" as in my example. They can have random names and can be more than 3 sheets per workbook.

[esukei]

Try:

Please Login or Register  to view this content.

Thank you. This works if the Valuefile is already open.
How can I add a network path to a folder and open the Excel file in it automatically?

[jindon]

Change to

Please Login or Register  to view this content.

[esukei]

Change to

Please Login or Register  to view this content.

Thank you.
Unfortunately the line below gets always an error:

Please Login or Register  to view this content.

Attachment 809098

[esukei]

Ok I was able to get it running.
Thank you all for your help.

Please Login or Register  to view this content.