execute R by VBA

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

execute R by VBA

Hello everyone

I am using RExcel, an add-in for R to use R within MS Excel workbook. The add-in is freely distributed by Statconn. Pls refer http://www.statconn.com/ 
I need help to start writing VBA Macro to invoke and execute R to read .csv file.
This is the code what I made so far… but the compilation error was occured.

Public ActiveServerAtStart As Boolean

Sub Get_Value()

  MsgBox "R putting data into excel"
  Rinterface.RRun "z<-read.csv("F:\\mycsvfile.csv",header=TRUE)"
  Rinterface.GetArray "z", Range("Sheet1!A1")
End Sub

Here “mycsvfile.csv” is target file from which the data is needed to be retrieved. Get_Value() is macro name for the active worksheet. I want to get the data to the sheet1 (cell A1) of active work sheet.
Thanks in advance.