Hi Bram
Note: Application.FileSearch is not always working correct that's why
I use Dir.
If you search the archives you will find a lot of threads about problems with it.
--
Regards Ron de Bruin
http://www.rondebruin.nl
"BR4M" wrote in message ...
Thanks so much guys! I tried both macro's, and both worked perfectly.
You have no idea how much time you guys saved me. Also, this actually
makes it possible to do a sensitivity analysis of sorts, since I can
now more or less change 'set' values at will over the entire range of
workbooks.
I almost can't believe you guys helped out a newbie like me so fast and
so effectively. This board truly sets the standard.
Sincerely,
Bram Verhees
--
BR4M
------------------------------------------------------------------------
BR4M's Profile: http://www.excelforum.com/member.php...o&userid=16822
View this thread: http://www.excelforum.com/showthread...hreadid=320168