search for: runrfile

Hi, I'm using R-2.8.1 for windows. I wrote a script calls the RODBC package to run sql queries against an oracle database. It runs fine when run from the rconsole and returns a data.frame with a summary for a set of experiments. I want to run this script using the rinterface.RunRFile command in an excel plugin, using the rexcel package. When I run the code from my excel plugin I get an error: "Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text="source(.rexcel..hzpouai)"))" Here is my excel plugin code: rinter...

...FileName.R") As mentioned in RExcel I can run by selecting the cell and choosing Run Code. I have tried to write the macro for this operation as the following: Sub FindIndex() ' To run the price index in R Application.DisplayAlerts = False Rinterface.StartRServer Rinterface.RunRFile "S:/Folder/FileName.R" 'RInterface.StopRServer Application.DisplayAlerts = True End Sub But it returns the error "Error when sourcing R file S:/Folder/FileName.R" I have also tried a simple RInterface.RRun("source(""S:/Folder/FileName.R"")&...

When I run a macro that uses RExcel, I get a dialog box that says "Microsoft Excel is waiting for another application to complete an OLE action." There is no error in the RExcel commands in the macro, of that I am sure. The box appears to be related to the inclusion of RunRFile commands. The macro will run through the second RunRFile command, but will not execute the Worksheet.Pictures.Insert statements or the GetArray statements until the user clicks OK on the dialog box. Any insight into how I can avoid the dialog box would be appreciated. The macro is below. It...

Hi, I am hoping you may be able to help please? I am trying to use R Excel to run an R script using "RInterface.RunRFile" I have tested this command on basic scripts and they work fine. However when I try to run quite a long script which runs a number of forecasts using the forecast package, linear regressions and then tries to print and excel workbook I get the error Microsoft Excel is waiting for OLE action....

...9;test', one cell A1 containing : smalltest(NA)) Macro : Sub smalltest() Range("A3").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents Call RInterface.StartRServer Call RInterface.RunRFile("h:\R-Sources\smalltest.r") Windows("smalltest.xls").Activate CommandString = Range("test!a1") MsgBox (CommandString) Call RInterface.RRun("CommandString") Workbooks.Open Filename:="c:\windows\temp\resultat.csv" Range(Selecti...

I have an R file R_test.R saved in C:\R_test folder. The R_test.R looks like this: setwd("C:/R_test") rnorm(100) write(rnorm(100),"data.txt") q(save="no", runLast = F) Next I would like use an Excel VBA/macro Shell() function to call R and execute R_test.R file. The syntax is *Shell(pathname*[*,windowstyle*]*)* I wrote an Excel macro RunRcode like this: Sub

...------------------- Dim Link_Ratio() As Double [...] No_of_Years = Application.WorksheetFunction.Count(Worksheets("InputTriangle").Range("C15:IV15")) ReDim Triangle(No_of_Years, No_of_Years) ReDim Link_Ratio(No_of_Years) [...] ' Calling some R functions Call rinterface.RunRFile(Functions_String) ' Input For ID_Col = 1 To No_of_Years Link_Ratio(ID_Col) = Worksheets("Projection").Cells(Start_Row, Start_Col + ID_Col - 1).Value Use(ID_Col) = Worksheets("Projection").Cells(Start_Row + 1, Start_Col + ID_Col - 1).Value Next ID_Col Call rinter...

Hi, I am running a test to call an R script with in excel using VBA. My VBA code is shown bellow. The middle section of this mail also includes the content of my Rscript. The bottom part shows the error message form the R console. It seems that Excel is opening the R console without any problems. The problem I am seeing is that Rinterface.RRun instruction is interpreting the "\T"