nabinbgr
asked on
batch file within excel vba
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 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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS 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.
SOLUTION
THIS SOLUTION IS 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.
split between
https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=23324989#a23324989
AND
https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=33123310#a33123310
The logic is sound from a high level perspective, and answers the question on how to wait while external processes are running.
https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=23324989#a23324989
AND
https://www.experts-exchange.com/questions/24034730/batch-file-within-excel-vba.html?anchorAnswerId=33123310#a33123310
The logic is sound from a high level perspective, and answers the question on how to wait while external processes are running.
Windows Batch
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.
13K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Not enough information to confirm an answer.