START / RUN Command - VBA to execute a DTF file

R

ricky

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AS400 transfer diredtly to xl sheet 6
Running Queries in Another Access DB 3
Copy and Paste a formula as Values in a fixed Range as a loop statement using VBA 1
Execute a query from a Form and output to Excel 2
How to execute a command in VBA 2
execute .acsup script from VBA macro 3
How can I run a ".cmd" command string from within MS Access? 3
Pass Query Paramater to populate form 5

Top