copy entire sheet from closed workbook and insert into another workboook when opened

Hello everyone.

I'm hoping you can assist me.

I have 2 workbooks. What I want to do, is when one workbook is opened it will run a macro (on open) that goes to a closed workbook, copies a sheet from it and then inserts that sheets information into a sheet in the now open workbook.

I'm completely new to this so your assistance, patience and understanding would be greatly appreciated.

Cheers
Mike

Dear tombie,

You can try someting like this :

Please Login or Register  to view this content.

Have fun!

Yup nice job,

You could also change your code using this:

Please Login or Register  to view this content.

It has the advantage that your workbook does not need to be active for the macro to work.
But if the workbook is active anyway, your code works fine.


<== Say thanks by clicking on the star !

Have fun