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,

"Tom" wrote:

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?