search for: runrfile

Displaying 8 results from an estimated 8 matches for "runrfile".

2009 Jan 30
1
run query using rexcel runrfile and rodbc sql query
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...
2011 Sep 09
0
RExcel - RunRFile Errors
...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"")&...
2009 Feb 06
0
RExcel waiting for OLE action
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...
2013 Oct 02
1
R Excel - Microsoft Excel is waiting for OLE action
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....
2005 May 26
1
Help needed - Use of RSrvr in macro mode
...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...
2010 Apr 18
2
how to use Excel VBA's Shell() to call and execute R file
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
2008 Jun 05
1
R-code embedded in VBE -- Type mismatch errors
...------------------- 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...
2011 Apr 01
4
Rexcel path problem
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"