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

[Guest]

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]

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.

 

[Guest]

Thanks a lot, Dave.

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.