macro to copy entire workbook to another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 04 Dec 2007 15:37 GMT

Hi, I'm having trouble trying to create macro to copy an entire workbook to
another workbook using VB. Eventually I would like to be able to have one
workbook open and have it copy to multiple workbooks.. Any ideas on how to
do this?

Reply to this Message

Ashish Dutt Sharma - 04 Dec 2007 16:15 GMT

Hi,

I wonder what all things do you wish to copy?

If it is the whole file, you could iterate through the activeworkbook.save
as ..

If anything else, you can call Application.Workbooks.Add to return a new
workbook,and use the object to copy stuff...

If it is specific sheets then Activesheet.copy...
If specific range then range.Copy

etc...

Regards,

> Hi, I'm having trouble trying to create macro to copy an entire workbook to
> another workbook using VB. Eventually I would like to be able to have one
> workbook open and have it copy to multiple workbooks.. Any ideas on how to
> do this?

Reply to this Message

Tom - 05 Dec 2007 14:07 GMT

Hi,

The open workbook is called 15.xls. What I'm trying to do is copy this
workbook to a destination workbook called "template.xls" and have that
entire workbook 15.xls to appear on the template on the sheet called
"Inventory3.xls" Any help on how u write a quick macro for this would be
greatly appreciated.

Thanks,

Tom

> Hi,
>
[quoted text clipped - 17 lines]
> > workbook open and have it copy to multiple workbooks.. Any ideas on how to
> > do this?

Reply to this Message

ilia - 05 Dec 2007 16:14 GMT

You want an entire workbook to appear on one sheet? Or is
Inventory3.xls a workbook?

> Hi,
>
[quoted text clipped - 31 lines]
>
> - Show quoted text -

Reply to this Message

Tom - 07 Dec 2007 17:37 GMT

Hi ilia,

I might have confused you a bit. In the workbook called Template.xls.
Sheet2 is called Inventory3.. I hope I explained myself a bit better this
time around. lol Yes we want 15.xls to appear on sheet2. Any help with this
would be much appreatied.

thank you for answering my post.

> You want an entire workbook to appear on one sheet? Or is
> Inventory3.xls a workbook?
[quoted text clipped - 34 lines]
> >
> > - Show quoted text -

Reply to this Message