Code for copying sheets from opened workbooks

[Bishonen]

Hi all,

I'm looking for a code to loop through all opened workbooks and look whether there's a worksheet called wkly. sum.. If such a sheet exists, I would like it to be copied to a new workbook and rename the sheet to the name of the workbook from which it was copied from. If for example 3 workbooks contain a sheet named wkly. sum., I would like them all to be in one workbook at the end (not 3 workbooks).

I hope I made myself clear :-)

Thanks in advance

[Bishonen]

as proof that im not lazy (just bad lol), I'll attach the code that i came up with

Please Login or Register  to view this content.

[arlu1201]

So you need to check the workbooks open at that particular time on your system? Or do you want to check the workbooks which are in a folder?

[Bishonen]

So you need to check the workbooks open at that particular time on your system? Or do you want to check the workbooks which are in a folder?

I would like to check all workbooks which are open at that particular time. I've updated the code in my second post (it makes sense to me, but it still won't work :/)

[Bishonen]

Does anyone have a spare minute to take a look @ the code i attached ? I got the feeling that I'm close to getting there (i manipulated the code here and there and I'm able to copy all desired sheets but I have to specifically tell where they shall go to (I have to know the names of the sheets where they come from too - which is a very bad thing ^^).

[arlu1201]

This is your updated code

Please Login or Register  to view this content.