Dear fazal

in the below link you can get how to open all the sheets in a given
folder.
http://www.ozgrid.com/forum/showthread.php?t=21322

i guess this will be solution to your first step of the problem.

Regards
Raza


--
RAZA
------------------------------------------------------------------------
RAZA's Profile: http://www.excelforum.com/member.php...o&userid=34186
View this thread: http://www.excelforum.com/showthread...hreadid=539270