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
MsgBox "R putting data into excel"
Rinterface.GetArray "z", Range("Sheet1!A1")
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.