I need to search for a workbook (in the folder there are ca. 10 of
them). In one workbook I have a dropdown menu, where the user can
choose a keyword According to that keyword, I need to choose the right
workbook and do some data transfers to the first book. But that's
another story, first I need a way to get the right workbook.

I'm waiting for any help!

Hi,

Check out the response to my post, exactly 6 posts up (after yours), entitled:

"Search Excel files for text and keywords"

HTH.

"Juuljus" wrote:

I need to search for a workbook (in the folder there are ca. 10 of
them). In one workbook I have a dropdown menu, where the user can
choose a keyword According to that keyword, I need to choose the right
workbook and do some data transfers to the first book. But that's
another story, first I need a way to get the right workbook.

I'm waiting for any help!