i want to create a separate files of branch with all sheet

  • Please help me from this file i want to create a separate files of branch with all sheets and i want to sent that to separate in mail on defined list mail id.

    Files

    • Rough.xlsx

      (143.9 kB, downloaded 82 times, last: )
  • I can get you all the workbooks into a temp folder.


    Hopefully somebody can see what is wrong with my email part,

    as soon as the code runs through the email part, vNum becomes empty and just goes to end sub


    You are one step closer though.


  • Thanks Alot It is working only mail is not work and one more thing can we automate sheet change like if in any file i have sheet more than this 3 than how can automate to change the sheet with loop.

  • This will create the workbooks with variable number of worksheets.

    Keep the "Rough.xlsm" workbook in a separate folder, then when running the code it will place the new workbooks in that folder.