Closing 2nd WorkBook

  • I start my code in 1 workbook, this code will open a file in another workbook so i can copy information to my main workbook, i would like to close the 2nd workbook once i'm done with it.

    i can't seem to get the last 2 lines to work. i have set 'sourcebook' to be a workbook at the beginning of the macro.

    any thought would help

    Thanks Brian G.

    [SIZE="6"][FONT="Comic Sans MS"]Brain G.[/FONT][/SIZE] :loopain:

  • Re: Closing 2nd WorkBook

    Hi Brian

    If I understand you correctly the code below should suffice

Participate now!

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