Hello Everyone, I want help regarding to write VBA Macro code to execute R Statistical software to retrieve data from third party applications for example, Spreadsheet or Comma Separated Values file (.csv file).
I have RExcel add-in activated in my Spreadsheet. RExcel is integration between Excel and R Statistical Software. RExcel is downloadable from www.statconn.com This is what I made so far… but got compilation error. Public ActiveServerAtStart As Boolean Sub GetValue() MsgBox “R retrives data” Rinterface.StartRServer Rinterface.RRun “z<-read.table(“F:\\CsvFile”, header=TRUE)” Rinterface.GetArray “z”, Range(“Sheet1!A1”) Rinterface.StopRServer End Sub() CsvFile is my target file from which I need to retrieve data. GetValue() is my macro name for the active work sheet. Thanks in advance. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
