Link to home
Create AccountLog in
Avatar of Bharat Guru
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.
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

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