I downloaded the driver guide - thanks that was a help. But I am running into a problem. I tested the function you gave me above and it worked great. But when I tried to apply it to a slightly more complicated shell command, the app i ran with the shell command froze just after opening it. I am calling a program called axys32.exe, which creates a text file. When it is called, it is supposed to run a script (hence "taxlots.scr") and return a text file. The 4 variable names after it are 4 paramaters that I need to pass to axys32. This shell command works fine if i use it separate from the LaunchApp32 function. If i call it on its own it runs fine, but I need to wait for it to finish before i run the DoCmd.TransferText line. When I call it from with the LaunchApp32 function, axys32.exe freezes immediately after it opens, and the script never runs. Any ideas?
Here is the code:
If LaunchApp32("s:\axys3\axys32.exe taxlots.scr " & _
acatFilenameUtah & " " & acatFilenameLocal & " " & _
accountFilename & " " & settledAcatFilename) = True Then
DoCmd.TransferText acImportDelim, "SettledSpec", "tblDailySettled" _
, "s:\axys3\taxlots\settledAccounts.txt"
End If