hi all,

would you help me,
i need to merg 5 excel books mybe more , at one excell book ,

ex.. i have 5 excell books (names) as under, at my folder e:\ddata1,

any idea how i can put all, at one book with name as ALLCustomerlist.excel

CustomerList-1214-Report20051106052251 && or any small name
CustomerList-1214-Report20051030061028
CustomerList-1214-Report20051023055035
CustomerList-1214-Report20051016053609
CustomerList-1214-Report20051009053220
CustomerList-1214-Report20051002064258

thanks