Email copy of Active Workbook without closing the workbook

  • I have several versions of emailing code for this with the same results. I am trying to create a temporary copy of the workbook I am using that gets emailed. The undesired side effect is that the workbook closes automatically and I need it to remain open. (Also, any tips on cleaning up my code would be greatly appreciated.)


    Here is my code:


  • Re: Email copy of Active Workbook without closing the workbook



    Give this a try :)

    [SIZE=3]The Only Dumb Question Is A Question Not Asked.[/SIZE]

Participate now!

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