Run a dos command in Access?

[Judy Ward]

Is it possible to run a command that you would run at a dos prompt and get
the response back within Access?

Thank you,
Judy

 

[Daniel]

Check out the following, I use it and it works great!

http://www.j.nurick.dial.pipex.com/Code/VBA/vbPerlish.htm

Be sure to download the Shell32 modules as well for it to work (it's in the
instructions).

Daniel P

 

[Judy Ward]

Daniel, thank you very much for responding. This looks like exactly what I
needed to know (I will try it out next week).

Thanks again,
Judy

 

[John Nurick]

Hi Judy,

You have to pipe the output from the command into a text file, then open
the file and have your way with its contents. I've written a VBA
function qx() to encapsulate this: you'll find it at
http://www.j.nurick.dial.pipex.com/Code/VBA/vbPerlish.htm