Bharat Guru
asked on
Excel VBA How to copy sheet2 from one file into Output.xls
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)
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER