Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shell & VBA
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...o&userid=18607 View this thread: http://www.excelforum.com/showthread...hreadid=498000 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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...o&userid=18607 View this thread: http://www.excelforum.com/showthread...hreadid=498000 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell | Excel Programming | |||
VBE COM Add-in Shell | Excel Programming | |||
xp shell command using vba | Excel Programming | |||
Shell | Excel Programming | |||
shell out of excel into another app | Excel Programming |