START / RUN Command - VBA to execute a DTF file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ricky - 11 Sep 2006 14:42 GMT

Hi

I have a DTF file which I execute through the Start/Run and then I paste a
pathname in.

Is it possible to do this through code.

I suppose what I am asking for is, is it possible to simulate through code,
the START/RUN action from the Windows desktop?

Kind Regards

Ricky

Reply to this Message

Bryan in Bakersfield - 11 Sep 2006 18:58 GMT

The Shell function lets you run an executable program from within VB.

X = Shell(pathname[,windowstyle])

where pathname is the full path and filename of your program. It returns
the task ID which it would populate in X, although I've never seen a use for
it (the task ID not the Shell).

If you need Access to wait for it, then check out
http://www.mvps.org/access/api/api0004.htm for making Access wait until the
process is finished.

> Hi
>
[quoted text clipped - 9 lines]
>
> Ricky

Reply to this Message