Run a dos command in Access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Judy Ward - 03 Mar 2007 03:14 GMT

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

Reply to this Message

Daniel - 03 Mar 2007 12:19 GMT

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

> 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

Reply to this Message

Judy Ward - 03 Mar 2007 15:30 GMT

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

> Check out the following, I use it and it works great!
>
[quoted text clipped - 10 lines]
> > Thank you,
> > Judy

Reply to this Message

John Nurick - 03 Mar 2007 20:51 GMT

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

>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

--
John Nurick [Microsoft Access MVP]

Please respond in the newsgroup and not by email.

Reply to this Message