Copy worksheet to closed workbook(sheet 3)

  • Hi


    I need to copy a worksheet to a closed workbook in sheet 3. I have a macro that did some calculation in activeworkbook. So I need to delete a closed workbook in sheet 3, copy the sheet from activeworkbook and paste to closed workbook sheet 3. How do I do that in vba?

  • Re: I need to copy a worksheet to a closed workbook in sheet 3

    You cannot copy a sheet into a sheet. You can copy and paste ranges between sheets.


    Re: So I need to delete a closed workbook in sheet 3

    Is the name of the workbook to be deleted in sheet3? Where is the path to the workbook?


    Re: copy the sheet from activeworkbook and paste to closed workbook sheet 3

    1) You just deleted the closed workbook

    2) Again, you cannot copy a sheet into a sheet.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!