[Rcom-l] Option to start RExcel in foreground and background

2008-07-21 Thread ryan . sheftel
Is it possible in my VBA code to start the RExcel session in either foreground or background mode based on a parameter, and that ignores the setting of the user. An example pseudo-code would be: RInterface.StartRServer("foreground") or RInterface.StartRServer("background") I once saw how do

Re: [Rcom-l] RE: Problem in calling R in Excel

2008-07-21 Thread Erich Neuwirth
RExcel as a macro RunFromRFile which allows you to give it a filename in Excel-Windows format (single backslashed) and then sources it. Iqbal Hussain wrote: Your problem might be in the string you are passing to RInterface.RRun Try something like this: Sub test() Dim code As String c

[Rcom-l] RE: Problem in calling R in Excel

2008-07-21 Thread Iqbal Hussain
Your problem might be in the string you are passing to RInterface.RRun Try something like this: Sub test() Dim code As String code = "source('c://global//source//admin//porto.r' )" Call rinterface.RRun(code) End Sub From: [EMAIL PROTECTED] [mailto:[EMAIL PRO