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

R

Ray

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.
 
D

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.
 
R

Ray

Thanks a lot, Dave.


Dave Peterson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top