Solved

How can I add new sheet from macro or batch processing?

Posted on 2016-10-10
2
22 Views
Last Modified: 2016-11-11
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.
0
Comment
Question by:Bharat Guru
2 Comments
 
LVL 31

Accepted Solution

by:
Rob Henson earned 500 total points
ID: 41837001
As far as I know, the workbook (file) has to be opened for you to add a worksheet to it. However, the appearance of the file opening can be hidden by not updating the screen.
0
 
LVL 13

Expert Comment

by:frankhelk
ID: 41883551
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
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now