asked on
How can I add new sheet from macro or batch processing?
How can add new sheet from worksheet1 to worksheet2 without opening worksheet2?
I basically wants to add newsheet using vba or any kind of Batch processing without opening a worksheet. I want to add new sheets to 50 different xls files all files in one directory.
I basically wants to add newsheet using vba or any kind of Batch processing without opening a worksheet. I want to add new sheets to 50 different xls files all files in one directory.
VBAMicrosoft Excel
Last Comment
Frank Helk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I have recommended this question be closed as follows:
Accept: Rob Henson (https:#a41837001)
If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
frankhelk
Experts-Exchange Cleanup Volunteer