<div>
<div class="content wysiwyg-content">
How can I loop through all files in folder and read all excel files and copy &quot;sheet2&quot; and copy it to Output excel file as new sheet. &nbsp;New sheet name will be the same as file name it copy from.<br />
<br />
For Example <br />
/File1.xls &nbsp; has three sheets (sheet1 , sheet2 and sheet3) <br />
/File2.xls &nbsp; has three sheets (sheet1 , sheet2 and sheet3)<br />
/File3.xls &nbsp; has three sheets (sheet1 , sheet2 and sheet3)<br />
<br />
Output <br />
Output.xls &nbsp;has three sheets (File1, File2, File3)<br />
<br />
Output.xls (SheetName will be File1, File2, File3)
</div>
</div>


How can I loop through all files in folder and read all excel files and copy "sheet2" and copy it to Output excel file as new sheet.  New sheet name will be the same as file name it copy from.

For Example 
/File1.xls   has three sheets (sheet1 , sheet2 and sheet3) 
/File2.xls   has three sheets (sheet1 , sheet2 and sheet3)
/File3.xls   has three sheets (sheet1 , sheet2 and sheet3)

Output 
Output.xls  has three sheets (File1, File2, File3)

Output.xls (SheetName will be File1, File2, File3)

Excel VBA How to copy sheet2 from one file into Output.xls

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

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.