Command Prompt

[shamas21]

Hi

Can someone tell me how I can open Command Prompt and start writing command lines to the Command Prompt window in VBA?

e.g. This opens the Command Prompt window but I need to write lines to it via VBA

     Shell ("cmd ")

Many Thanks

 

[boblarson]

I don't know that there is a way to do that. But you can create a batch file dynamically and then run it.

See the code in my Auto Update Enabler Tool which does just that.
http://downloads.btabdevelopment.com/Tools/Access_Front-End_AutoUpdating_Utility_rev06Sep2008.zip