[R] RExcel - RunRFile Errors
kenjiball at energyaction.com.au
Fri Sep 9 05:46:20 CEST 2011
I am using RExcel and trying to pass a line of code into R. When I select
the cell and choose "Run Code" from the RExcel menu then it seems to work
The problem I face is a need to write a macro to do this operation, as I
need to set up a user interface in excel for other users who don't know how
to use R.
In R to run my entire code I simply write on line:
As mentioned in RExcel I can run by selecting the cell and choosing Run
I have tried to write the macro for this operation as the following:
' To run the price index in R
Application.DisplayAlerts = False
Application.DisplayAlerts = True
But it returns the error "Error when sourcing R file S:/Folder/FileName.R"
I have also tried a simple
But it did not work.
Can anyone help me in writing this macro?
Thanks in advance.
View this message in context: http://r.789695.n4.nabble.com/RExcel-RunRFile-Errors-tp3800748p3800748.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help