Hi all -
I'm new to the forum and to Excel VBA. I'm hoping to learn more about VBA and I'm looking for some help.

I'm trying to write a macro that will copy a sheet from one excel workbook (the CopyFrom workbook) and copy it into a another workbook (CopyTo) that will be a compilation of these other worksheets. I've got the macro to copy the sheet ok (after finding code on the site) but a couple of things are happening that need some advice with -

1. I'm opening the CopyFrom workbook with workbooks.open, so I can see it opening. I'm using workbooks.worksheet.copy to copy the sheet. Is there a workbooks command that can be used instead of .open?

2. Because I'm using workbooks.open, the CopyFrom workbook remains open. How do I close it? It isn't the activeworkbook so the close method closes the CopyTo workbook. The simple thing to do is to set the CopyFrom workbook to the activeworkbook and then close it, but I don't know how to do it. Can someone help with the syntax / method??

I apologize for the simplicity of these questions. I have a VBA book coming to help with the syntax and methods.

Any help is greatly appreciated.

Thanks