Copying worksheets from several workbooks into one

[lilbird1981]

Hello,

I have several workbooks in one directory. All of those workbooks contain a worksheet which I want to copy into another workbook, where all of those worksheets are collected.

I have written the following code already:

Please Login or Register  to view this content.

The problem is, when I run this macro in all of my workbooks, then it simply overwrites the "allSheets" file.
My question is, how do I add worksheets to this file, so that I can collect all worksheets in that workbook?

Thanks,
Lily.

[Domski]

If you put this code in your allsheets.xls workbook and have it open you can then open the workbooks you want to copy from and when you run it the active sheet will be copied to allsheets.xls.

Please Login or Register  to view this content.

Dom