Johan,
Does this help ?

http://vbnet.mvps.org/code/fileapi/r...tipleselective.
htm

NickHK


"Frank Kabel" wrote in message
...
Hi Johan
so you're looking for a file search mechanism (which scans through
subdirectories)?

--
Regards
Frank Kabel
Frankfurt, Germany
"Johan" schrieb im Newsbeitrag
...
hello,

I'm trying to write code to open a workbook of which I don't know the
exact location.

Can anybody help me?

Thanks, Johan