How to create a VBA macro to export multiple worksheets to a new Excel file

Apr 22, 2020 | Excel, VBA | 5 comments

In this tutorial, we are going to write a macro using VBA, to export multiple worksheets from an Excel file (let’s call it the master Excel data file) to a new Excel file.

Buy Me a Coffee? Your support is much appreciated!
PayPal Me: https://www.paypal.me/jiejenn/5
Venmo: @Jie-Jenn





5 Comments

  1. MUSTAFA DARAKÇIOĞLU
    MUSTAFA DARAKÇIOĞLU on 2020-12-11 at 4:25 AM

    thank you very much

    Reply
  2. Darrel Antony
    Darrel Antony on 2021-05-27 at 12:41 AM

    HI Jie, Thanks so much for this quite helpful. However, how do I ensure that only the values and the formatting of the cells is kept when copied to the new sheet instead of copying the formulas as well? Much appreciated.

    Reply
    • Terry
      Terry on 2023-10-05 at 12:53 PM

      is there a way to do what Darrel Antony is saying so export the tabs into new workbook but only the values and or formatting?

      Reply
  3. Alvaro Antonio Vargas Vargas Ortega
    Alvaro Antonio Vargas Vargas Ortega on 2021-05-28 at 8:03 AM

    a GENIOUS

    Reply
  4. Moses
    Moses on 2022-03-24 at 11:52 PM

    Hi, Jie,

    How about if the worksheet list name in one column?

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *