Re: [Rcom-l] Error message

2008-04-24 Thread Erich Neuwirth
Is it possible that the R file ThisWorkbook.Path "\AnovaCI_Weekly.r" has a syntax problem? Error handling in this case is not yet as informative as it should be. Felipe Carrillo wrote: Call rinterface.PutDataframe("ByWeek", Range("Data!A1:E" & Range("E1").End(xlDown).Row)) Call ri

Re: [Rcom-l] RE: Rcom-l Digest, Vol 38, Issue 15

2008-04-24 Thread Erich Neuwirth
The Wiki at rcom.univie.ac.at has more information. Diego Mazzeo wrote: Probably a dumb question: where can I find information on what RAndFriends is? A Google search did not help. Thank you. Diego -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de [EMAI

[Rcom-l] RE: Rcom-l Digest, Vol 38, Issue 15

2008-04-24 Thread Diego Mazzeo
Probably a dumb question: where can I find information on what RAndFriends is? A Google search did not help. Thank you. Diego -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] En nombre de [EMAIL PROTECTED] Enviado el: Miércoles, 23 de Abril de 2008 07:00 a.m. Para: rcom

Re: [Rcom-l] Error message

2008-04-24 Thread Felipe Carrillo
Call rinterface.PutDataframe("ByWeek", Range("Data!A1:E" & Range("E1").End(xlDown).Row)) Call rinterface.RRun("attach(ByWeek)") rinterface.RunRFile ThisWorkbook.Path & "\AnovaCI_Weekly.r" 'I get an error message here --- Erich Neuwirth <[EMAIL PROTECTED]> wrote: > What code

Re: [Rcom-l] Error message

2008-04-24 Thread Erich Neuwirth
What code are you using to read the files? On Apr 24, 2008, at 9:09 PM, Felipe Carrillo wrote: Hi: I am getting the following message with the new RExcel Version (RExcelInstaller) Error-2147220502 In Module RExcel.RServer Error running expression eval(parse(text="close(rexcel..ahxirwf)")) Eve

[Rcom-l] Error message

2008-04-24 Thread Felipe Carrillo
Hi: I am getting the following message with the new RExcel Version (RExcelInstaller) Error-2147220502 In Module RExcel.RServer Error running expression eval(parse(text="close(rexcel..ahxirwf)")) Everything was working fine with the older version Rsrv250_p|1.exe. I am transferring 52 weeks of dat

Re: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Erich Neuwirth
This is an array with mixed data types. This is difficult to handle. I do a lot of analyzing for missing values in Excel sheets, but I cannot do that in VBA easily. What you are doing is not using missing values, but string values as placeholders for missing values. The next release (which is pr

RE: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Christian Prinoth
Sorry, that's just one of my concoctions, just replace it with a = array("1", 2, 3, "NA", 5, 6, 7, "#N/A", 9, 10) Right now I do this: Sub NumArr2R(VarName As String, arr) Dim n As Integer, i As Integer n = ismatrix(arr) If n = 0 Then arr = CStr(arr) ElseIf n = 1 Then

Re: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Erich Neuwirth
Handling missing values can be controlled when transferring data from Excel sheets to R. It is not implemented in detail when transferring data from VBA to R. Where does makearr come from anyway? It is neither a VBA function vor a function from RExcel. Christian Prinoth wrote: I often use the

Re: [Rcom-l] New RAndFriends

2008-04-24 Thread Erich Neuwirth
Try this one. It should solve both problems. http://rcom.univie.ac.at/download/devel/DCOMNoExcel.exe [EMAIL PROTECTED] wrote: Hi Erich, I installed RSrv250_pl2 and got the same error message as before, namely: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTy

[Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Christian Prinoth
I often use the above function to trasfer arrays to R from VBA. Sometimes these arrays have missing values, for example, I may have a = makearr("1", 2, 3, "NA", 5, 6, 7, "#N/A", 9, 10) If I do putarrayfromvba "a", a in R I get: > a [1] 1 2 3 0 5 6 7 0 9 10

Re: [Rcom-l] New RAndFriends

2008-04-24 Thread Erich Neuwirth
The xls files in RSrv250_pl2 are quite outdated. RAndFriends suppresses installation of these files. Please remove the xls directory in the (D)COM directory and then install RExcelInstaller from CRAN and run RExcelInstall. Or just run RAndFriends again after removing the xls directory under (D)C

RE: [Rcom-l] New RAndFriends

2008-04-24 Thread Wayne.W.Jones
Hi Erich, I installed RSrv250_pl2 and got the same error message as before, namely: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. It also complained that it could not find an Excel version comp

Re: [Rcom-l] New RAndFriends

2008-04-24 Thread Erich Neuwirth
Wayne, can you try using just running this installer http://rcom.univie.ac.at/download/devel/RSrv250_pl2.exe and see if you get the problems. Then we know a little better where to locate the issues. Erich [EMAIL PROTECTED] wrote: Hi Erich and fellow rcom users, I have been doing some test

RE: [Rcom-l] New RAndFriends

2008-04-24 Thread Wayne.W.Jones
Hi Erich and fellow rcom users, I have been doing some testing of the new RAndFriends including the new R 2.7.0 (RAndFriendsSetup2070V20.exe). I get the folowing error message when trying to install using Vista Ultimate edition: C\Windows\System32\stdole2.tlb Unable to register the type li