search for: commandstring

...").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(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.Co...

(R 1.9.1; Windows 2000;) I'm just comparing ease of use, speed, etc for methods of transferring data frames in the Excel, MySQL, R triangle. It turns out that going from Excel to R (when doing this carefully). Using the clipboard is actually quite fast and efficient (2 seconds for transferring 120 000 cells on a common desktop computer as compared to much longer for going the RODBC route,