Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to use redirection and it does not work.
*********** ds = InputBox("Type in reporting date as YYYY-MM-DD", "reporting date") exestr = "Rterm --restore --save < m.in.R out.txt --args " & ds ret = Shell(exestr) ' opens Rterm and does not source the script ************* if I put the string in a batch file aaa.bat and use ret=Shell(aaa.bat) then redirection works, but I lose the return value from the process. ret simply reports whether cmd started successfully. I need to have the value returned from Rterm, which is 0 upon successful finish and -1 otherwise. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Redirect source of pivot table | Excel Discussion (Misc queries) | |||
column redirect | Setting up and Configuration of Excel | |||
how do redirect | Charts and Charting in Excel | |||
Redirect formulas to a new sheet in workbook | New Users to Excel | |||
redirect from worksheet | Excel Discussion (Misc queries) |