Bharat Guru
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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