
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]]


