Displaying 1 result from an estimated 1 matches for "vbamacro".
Did you mean:
vamaro
2009 Jul 27
1
creating and populating an environment
Hi, I often work with R by writing long(ish) Excel-VBA macros
interspersed with calls to R via RExcel. A typical example of this would
be:
Sub VBAMacro()
'fetch some data from an excel sheet
'do some basic stuff on said data
'transfer data from vba to R
'run some R statements
'get data back to vba
'show results on the excel sheet
'clean R by deleting all vars that were created: rrun
"rm(a,b,c,....)"
end...