copy&paste of several sheets in a folder to a workbook with somesh
 

Hi, guys,

I need to copy and paste several sheets in different workbooks in a folder
to a old workbook with some other sheets.

Using Ron's Copy sheet from each workbook, I could only creat a new workbook
with the sheets I need. I can add the sheets to my old workbook?

Thanks a lot.

copy&paste of several sheets in a folder to a workbook with somesh
 

Someplace in Ron's code there's a line for BaseBook (he uses the variables to
make things easier).

He has something like:

set basebook = workbooks.add(...)

Instead, you could use:

set basebook = workbooks("oldworkbooknamehere.xls")

then test it out.

Ray wrote:

Hi, guys,

I need to copy and paste several sheets in different workbooks in a folder
to a old workbook with some other sheets.

Using Ron's Copy sheet from each workbook, I could only creat a new workbook
with the sheets I need. I can add the sheets to my old workbook?

Thanks a lot.

--

Dave Peterson

copy&paste of several sheets in a folder to a workbook with so
 

Thanks a lot, Dave.


"Dave Peterson" wrote:

Someplace in Ron's code there's a line for BaseBook (he uses the variables to
make things easier).

He has something like:

set basebook = workbooks.add(...)

Instead, you could use:

set basebook = workbooks("oldworkbooknamehere.xls")

then test it out.

Ray wrote:

Hi, guys,

I need to copy and paste several sheets in different workbooks in a folder
to a old workbook with some other sheets.

Using Ron's Copy sheet from each workbook, I could only creat a new workbook
with the sheets I need. I can add the sheets to my old workbook?

Thanks a lot.

--

Dave Peterson