VBA to copy sheets & rename to workbookname

sur

Board Regular
Joined
Jul 4, 2011
Messages
166
Hello Team,


we have requirement, where in i have the excel files in the folder, where i need to move in to one workbook with sheets names as workbooks names in the folder.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,089,947
Messages
5,411,457
Members
403,372
Latest member
andrepi

This Week's Hot Topics

Top