Shell and Wait

[Daniel Thomas]

I am using the code posted on the Access Web by Terry Kreft to shell and
wait for an application to finish before continuing. The application I am
shelling out to requires that the current directory be changed before it can
run successfully (because it calls another application using a relative
path). Can anyone post some advice that I could use to make this work.
Below is my code and the code from the Module.

----------------------------
My Form Code
----------------------------

strShellPathName = Mas_Scr_Hwd & "\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI
...\SOA\MAS90 -ARG ..\vi\" & viJobID & " W O DIRECT " & viMode & " " &
MAS_SCR_CMP
ShellWait (strShellPathName)

----------------------------
End My Form Code
----------------------------
A link to the code by Terry is below. I don't think it would be appropriate
for me to re-post his code without his permission, but it's available at the
following website:

http://www.mvps.org/access/api/api0004.htm

Thanks in advance for any ideas.

[Terry Kreft]

Daniel,
Interestingly I had a similar problem just this year, look at ChDrive and
ChDir to achieve this before your call to ShellWait.

Terry
"Daniel Thomas" <da****@goochsupport.com> wrote in message
news:vr************@corp.supernews.com...

I am using the code posted on the Access Web by Terry Kreft to shell and
wait for an application to finish before continuing. The application I am
shelling out to requires that the current directory be changed before it can run successfully (because it calls another application using a relative
path). Can anyone post some advice that I could use to make this work.
Below is my code and the code from the Module.

----------------------------
My Form Code
----------------------------

strShellPathName = Mas_Scr_Hwd & "\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI
..\SOA\MAS90 -ARG ..\vi\" & viJobID & " W O DIRECT " & viMode & " " &
MAS_SCR_CMP
ShellWait (strShellPathName)

----------------------------
End My Form Code
----------------------------
A link to the code by Terry is below. I don't think it would be appropriate for me to re-post his code without his permission, but it's available at the following website:

http://www.mvps.org/access/api/api0004.htm

Thanks in advance for any ideas.

[Bruce M. Thompson]

Response below.

I am using the code posted on the Access Web by Terry Kreft to shell and
wait for an application to finish before continuing. The application I am
shelling out to requires that the current directory be changed before it can
run successfully (because it calls another application using a relative
path). Can anyone post some advice that I could use to make this work.
Below is my code and the code from the Module.

----------------------------
My Form Code
----------------------------

strShellPathName = Mas_Scr_Hwd & "\PVXWIN32.EXE ..\LAUNCHER\SOTA.INI
..\SOA\MAS90 -ARG ..\vi\" & viJobID & " W O DIRECT " & viMode & " " &
MAS_SCR_CMP
ShellWait (strShellPathName)

----------------------------
End My Form Code
----------------------------

If the "relative path" is based on the location of pvxwin32.exe, then I suppose
you need to change the directory, prior to issuing the "ShellWait()" function
call, using:

'Ensure correct drive is the current drive
ChDrive Mas_Scr_Hwd
'Set current directory on current drive
ChDir Mas_Scr_Hwd

This is assuming that "Mas_Scr_Hwd" is a variable holding the path to the
referenced executable (the assumed baseline for the relative paths). Since I am
not familiar with the ProvideX software, you will need to refer to your user's
manual for more information.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.org (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<