Re: Shell() or Windows API question
From: gxdata (il_thomas_at_hotmail.com)
Date: 05/18/04
- Next message: Rob: "Re: Second Recordset?"
- Previous message: gxdata: "Re: Shell() or Windows API question"
- In reply to: RK: "Shell() or Windows API question"
- Next in thread: TC: "Re: Shell() or Windows API question"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 12:19:03 +0800
retval = Shell("CMD ""O:\Vincenty\B2.bat"" /C",1) - also fails to work
B2.BAT contains - inverse.exe < INPUT.TXT
and the files INVERSE.EXE and INPUT.TXT do exist in O:\Vincenty
ILT
"RK" <anonymous@discussions.microsoft.com> wrote in message
news:e61e01c43c86$ec25c900$a601280a@phx.gbl...
> Shell() cmd "my.bat" /c
>
>
>
> >-----Original Message-----
> >I have a DOS or command console program that was written
> in FORTRAN, and
> >accepts piped input when run from Windows 2000 Pro
> command prompt (or
> >Windows 98 DOS prompt) -
> >
> >INVERSE.EXE < INPUT.TXT
> >Running the above from DOS / command prompt works
> perfectly.
> >
> >Also, this works from an Access XP code module -
> > RetVal = Shell("O:\Vincenty\inverse.exe", 1)
> >giving just the console interface and requiring manual
> input; but I need to
> >pipe in the values stored in a file INPUT.TXT (or -
> better - pass a string
> >direct from a routine written in Access Visual Basic).
> >
> >I can't discover a way to achieve what I want from an
> Access subroutine. I
> >have tried Shell() with both direct and with various
> batch files -
> > RetVal = Shell("O:\Vincenty\inverse.exe < 1.TXT", 1)
> >or
> > RetVal = Shell("O:\Vincenty\inverse.exe < 1.TXT", 1)
> >and
> > RetVal = Shell("MyBatchFile1.BAT < INPUT.TXT", 1)
> >or
> > RetVal = Shell("MyBatchFile2.BAT", 1)
> >
> >where the batch files are 1 - inverse.exe < %1 and 2 -
> inverse.exe <
> >INPUT.TXT
> >
> >Everything run with Shell() from Access fails, when
> redirection (piped
> >inout) is specifdied - either directly or through a
> batch file. Note that
> >both of the batch files described above do work
> perfectly when run manually
> >from the DOS (command) prompt.
> >
> >I think I need some Windows API functions, and fairly
> elaborate ones. I
> >would appreciate suggestions.
> >
> >Ian Thomas
> >Perth, Australia
> >
> >
> >.
> >
- Next message: Rob: "Re: Second Recordset?"
- Previous message: gxdata: "Re: Shell() or Windows API question"
- In reply to: RK: "Shell() or Windows API question"
- Next in thread: TC: "Re: Shell() or Windows API question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|