Re: Shell & VBA

Maybe the simplest solution would be to add a couple of lines to the top of your
..bat file:

c:
cd\programdirectory
XCHANGE combined.txt "^39^44^39" "^39^124^39"

===
change to the correct drive (C:)
change to the correct folder
run the command.

combined.txt will end up in that same folder, right???

----

Untested!

Vikxcel wrote:
>
> Ok, this question may be simple, but it's not clicking with me...
> So in my vba code for excel I execute a number of .bat files using
> SHELL command. Now, I needed to find a DOS program or command that
> would do something special for me, so I found a xchange.exe on the web
> that does EXACTLY what i'm looking for. So I set it into my Program
> Files\my program directory, where my batch file is sitting at.
> In my batch I run that file on a number of text files.
> When manually I execute this batch file, it works fine.
> But in VBA Shell it does not run.
> Question, do I need to place or load that special exchange.exe into
> something???
> This is what i have in my batch file, or cmd file.
> XCHANGE combined.txt "^39^44^39" "^39^124^39"
>
> --
> Vikxcel
> ------------------------------------------------------------------------
> Vikxcel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18607
> View this thread: http://www.excelforum.com/showthread.php?threadid=498000

--

Dave Peterson
.

Relevant Pages

  • Re: VFP 6 - problem with RUN command
    ... I think you simply need to de-bug your .bat file. ... Toos VFP to the side for ... The PAUSE command, however, functions beautifully now. ... and a CALL command to another batch file doesn't work, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP 6 - problem with RUN command
    ... Does your .BAT file run OK if you run it from Windows Explorer? ... and a CALL command to another batch file doesn't work, ... If I place a SUSPEND command immediately before the RUN command, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Command Line Question about Renaming Files
    ... It had to do with how I was sending the commands to the command processor. ... this bat file to work. ... It does rename itself in the process and generates an error, ... I don't fully understand how your batch file works, ...
    (microsoft.public.win2000.general)
  • Re: Getting system uptime on Windows
    ... batch file and then using exec on the .bat file. ... is in the user´s preferred language, so some fancy parsing is required ... I don´t think this command is available on Windows 98. ...
    (comp.lang.tcl)
  • Re: Send Access Data to a Batch file
    ... The normal way of passing parameters to a batch file is to include them ... on the command line and reference them in the file as %1, ... I'm using the shell command ... >ECHO ENTER YEAR ...
    (microsoft.public.access.externaldata)
Loading