$$Excel-Macros$$ macro that will combine workbooks

hi I have several work books having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thnks in Advance Regards Debasish --~--~-~--~~~---~--~~ Visit the blog to download Ex

$$Excel-Macros$$ macro that will combine workbooks

Hi I have several work books(excel files) having contact details in a folder (with same headers). Now I want to merge all files in to one sheet. Could somebody please provide a macro for this. Thanks in Advance Regards Debasish -- debasish sahu IIT Bombay. --~--~-~--~~