Tom,

I was not able to get any output from your code, bcoz it gives me debu
messages. Whereas..


Patrick,
Your code was successful to import sheets only if array containin
names matches with workbook sheet names.

But what about if array containing names does not found any i
workbook???
Suppose workbook does not contain sheets which are required to import
then display msgbox with its sheet-name not found.

Plz check the same and let me know

--
ilyaskaz
-----------------------------------------------------------------------
ilyaskazi's Profile: http://www.excelforum.com/member.php...fo&userid=2396
View this thread: http://www.excelforum.com/showthread.php?threadid=37667