STUCK - Need to get a dos prompt

[grovithis]

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

 

[Ivan F Moala]

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>

 

[grovithis]

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

 

[grovithis]

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