Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run external program.
Hello,
I have this macro (I'am trying remove all " from some txt file): Set objshell = CreateObject("WScript.Shell") objshell.Run "%comspec% /c gsar.exe -s"""""" -r -o ""C:\Program Files\Test\test.txt""", 1, True gsar.exe is in c:\windows and it works, but when I edit this macro like that: Set objshell = CreateObject("WScript.Shell") GsarPath = "gsar.exe is ingsar.exe" objshell.Run "%comspec% /c """ & GsarPath & """ -s"""""" -r -o ""C:\Program Files\Test\test.txt""", 0, True gsar.exe is in gsar.exe is in, it dosnt work. Can you help me? Thanks Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run external program.
Seems like you should get something running that has spaces in the name like
GsarPath does. Then you can substitute in a variable in the string. What you have now produces pretty much what works except it puts double quotes around the gsar.exe is ingsar.exe where in your original, gsar.exe has no quotes around it. Maybe you need single quotes rather than double quotes. I can't say. -- Regards, Tom Ogilvy "Tom" wrote in message ... Hello, I have this macro (I'am trying remove all " from some txt file): Set objshell = CreateObject("WScript.Shell") objshell.Run "%comspec% /c gsar.exe -s"""""" -r -o ""C:\Program Files\Test\test.txt""", 1, True gsar.exe is in c:\windows and it works, but when I edit this macro like that: Set objshell = CreateObject("WScript.Shell") GsarPath = "gsar.exe is ingsar.exe" objshell.Run "%comspec% /c """ & GsarPath & """ -s"""""" -r -o ""C:\Program Files\Test\test.txt""", 0, True gsar.exe is in gsar.exe is in, it dosnt work. Can you help me? Thanks Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to pass a cell as parameter for an external program? | Excel Discussion (Misc queries) | |||
Copying data to an external Program | New Users to Excel | |||
Can I run an external program? | Excel Programming | |||
How do I run an external program? | Excel Programming | |||
Open external program | Excel Programming |