View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Replacing (identical) values in multiple workbooks simultaneously?

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