loop through workbooks in folder copy "jan" sheet into new workbook

**Sirishgreen** · 05-23-2008, 06:33 AM

Hi all,

I have some code which can be seen below, the attatchment shows what is happening at the minute if you copy the folder to root of "c:\" it wont work!

Please Login or Register  to view this content.

its suppose to copy all january sheets from all workbooks into 1 workbook.

Thanks,
Simon Green

**antoka05** · 05-23-2008, 10:32 AM

I modified some little things in your code and now it seems to work fine:

Please Login or Register  to view this content.

Regards,
Antonio

**Sirishgreen** · 05-23-2008, 11:37 AM

Thanks for that. It did appear to be working at first. But its only creating a new sheet using the cell 1,1 for the name. It isnt copying if you enter data into john then try the macro. John is just a blank sheet. But a real step in the right direction THANK YOU!! all we need to do now is to get it copying.

Simon Green

**Sirishgreen** · 05-27-2008, 04:58 AM

Is there anybody who can help with this?

**jindon** · 05-27-2008, 05:33 AM

Please Login or Register  to view this content.

**royUK** · 05-27-2008, 06:00 AM

Your example workbook test2 does not contain a sheet called "Jan", so nothing will copy. Your code works fine when it actually finds the sheets.

PS, you should stick to the original post not start a new one.