<div>
I've requested that this question be deleted for the following reason:<br />
<br />
Not enough information to confirm an answer.
</div>


<div>
split between <br />
<br />
<a href="https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=23324989#a23324989" rel="ugc">https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=23324989#a23324989</a><br />
<br />
AND <br />
<br />
<a href="https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=33123310#a33123310" rel="ugc">https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=33123310#a33123310</a><br />
<br />
The logic is sound from a high level perspective, and answers the question on how to wait while external processes are running.
</div>


<div>
<div class="content wysiwyg-content">
I have a batch file in shell within excel vba code. batch file name is &quot;C:\CLG\newfile.bat&quot;<br />
I have to make the vba code run only after the batch is complete.<br />
I want to make all the control buttons on the excel sheet ineffective while the batch is running<br />
Again can I make the command window full screen in a batch script
</div>
</div>


I have a batch file in shell within excel vba code. batch file name is "C:\CLG\newfile.bat"
I have to make the vba code run only after the batch is complete.
I want to make all the control buttons on the excel sheet ineffective while the batch is running
Again can I make the command window full screen in a batch script

I&#39;ve requested that this question be deleted for the following reason:

Not enough information to confirm an answer.

split between 

http://www.experts-exchange.com/Programming/Languages/Scripting/Shell/Batch/Q_24034730.html#a23324989

AND 

http://www.experts-exchange.com/Programming/Languages/Scripting/Shell/Batch/Q_24034730.html#a33123310

The logic is sound from a high level perspective, and answers the question on how to wait while external processes are running.

batch file within excel vba

I have a batch file in shell within excel vba code. batch file name is &quot;C:\CLG\newfile.bat&quot;
I have to make the vba code run only after the batch is complete.
I want to make all the control buttons on the excel sheet ineffective while the batch is running
Again can I make the command window full screen in a batch script

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.