<div>
I would also go for the batch file. you can redirect the output to a file with &gt;&nbsp;to capture the return commands<br />
example<br />
cmd.exe program.bat &gt;&nbsp;output.txt
</div>


I would also go for the batch file. you can redirect the output to a file with > to capture the return commands
example
cmd.exe program.bat > output.txt

<div>
Thanks for the input everyone. &nbsp;I had a feeling I would be using a batch file for this (which implemented today).<br />
<br />
Just wanted to see if anyone had success with carrying over the variables directly. <br />
<br />

</div>


Thanks for the input everyone.  I had a feeling I would be using a batch file for this (which implemented today).

Just wanted to see if anyone had success with carrying over the variables directly.



<div>
<div class="content wysiwyg-content">
Hello, &nbsp;I would like to take variables from a VBA form and insert them into a series of DOS commands. &nbsp;For example, &nbsp;the program would open a MS DOS window using<br />
<br />
Call Shell(&quot;cmd.exe&quot; &amp;&nbsp;dosCmd, vbNormalFocus)<br />
<br />
then I would like &nbsp;text field1 from the form inserted into the MS DOS command line and a return command. This would be followed by &nbsp;text field2 from the form inserted and a return command supplied.<br />
<br />
This will go on until all the user supplied information from the form have been entered into MS DOS. &nbsp;I am not sure how I can carry over these variables into MS DOS and how to execute the line. <br />
<br />
thanks
</div>
</div>


Hello,  I would like to take variables from a VBA form and insert them into a series of DOS commands.  For example,  the program would open a MS DOS window using

Call Shell("cmd.exe" & dosCmd, vbNormalFocus)

then I would like  text field1 from the form inserted into the MS DOS command line and a return command. This would be followed by  text field2 from the form inserted and a return command supplied.

This will go on until all the user supplied information from the form have been entered into MS DOS.  I am not sure how I can carry over these variables into MS DOS and how to execute the line. 

thanks

Using VBA variables in MS DOS

Microsoft Disk Operating System (MS-DOS) was an operating system for x86-based personal computers, and traces of it are still found in the Windows operating system. DOS is still used in some embedded systems and for certain legacy 16-bit networks.

Microsoft DOS

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.