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.

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

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
>