Hi, I'm using R 1.7.1 and R (D)COM Server V1.2 with Excel 2000 SR-1.
In an older version of the Com server, I would call a pre-made workspace using
load('filename') from VBA. When I try to use load or source, R cannot
seem to find the files. I can load and source fine from an interactive R prompt,
but calling these functions from VBA is giving errors.
Specifically, the error for
Call RInterface.RRun("load ('WSpace.RData')")
is
Error while evaluating
load ('WSpace.RData')
evaluation stopped because of an error
Error in open.connection (con, "rb") : unable to open connection
In addition: Warning message:
cannot open compressed file `WSpace.RData'
and the error with Call RInterface.RRun("source ('func.txt')")
is
Error while evaluating
source ('func.txt')
evaluation stopped because of an error
Error in file(file, "r") : unable to open connection
In addition: Warning message:
cannot open file `func.txt'
Again, these commands work fine from an R prompt. Hopefully I'm not missing
something completely obvious.
Thanks,
Max
---------------------------------
[[alternative HTML version deleted]]