<div>
why dont you copy the old file and rename it and delete the tabs you dont want
</div>


why dont you copy the old file and rename it and delete the tabs you dont want

<div>
I have over 25 tabs in the workbook. &nbsp;Seems inefficient to do it that way.
</div>


I have over 25 tabs in the workbook.  Seems inefficient to do it that way.

<div>
nicely done. &nbsp;good starting point. &nbsp;thanks
</div>


nicely done.  good starting point.  thanks

<div>
<div class="content wysiwyg-content">
I have a workbbok with many tabs. &nbsp;I would like to have two of the tabs copied out to a new excel file which only contains these two sheets. &nbsp;The two sheet I want to copy are called &quot;data&quot; and &quot;report&quot;. &nbsp;I want a new excel file that has these two sheets, &nbsp;Can I do this through VBA?
</div>
</div>


I have a workbbok with many tabs.  I would like to have two of the tabs copied out to a new excel file which only contains these two sheets.  The two sheet I want to copy are called "data" and "report".  I want a new excel file that has these two sheets,  Can I do this through VBA?

Copy select Excel sheet from workbook to new workbook

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.