STUCK - Need to get a dos prompt

grovithis

New Member
Joined
Apr 28, 2002
Messages
15
HI hope you guys can help

i need to run a dos command in my vba script
Is it possible???
ie : run a file transfer from a as 400 machine wich is already done

Ps if you guys want a real laugh you must have a look at my vba stuff i use indicators and stuff (from RPG) but hey it works
 

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
On 2002-04-29 01:42, grovithis wrote:
HI hope you guys can help

i need to run a dos command in my vba script
Is it possible???
ie : run a file transfer from a as 400 machine wich is already done

Ps if you guys want a real laugh you must have a look at my vba stuff i use indicators and stuff (from RPG) but hey it works

Any help ??

<pre/>
Sub Run_dos()

Shell "C:command.com", vbNormalFocus

End Sub
</pre>
 
Upvote 0
Thanks a lot Ivan

Saved my but
now all i have to do is figure out how to
write (ie type in the words in dos)

if you have any ideas great will really
appreciate it
 
Upvote 0
I think i got it

instead of calling the command .com just tell
vb to run a .bat filr

eg
Sub Run _bat()

Shell "C:test.bat", vbNormalFocus

End Sub
again thanks a lot Ivan
 
Upvote 0

Forum statistics

Threads
1,213,553
Messages
6,114,279
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top