Re: [Rcom-l] Installing RExcel 3.0.1 and Visual Basic 400 error

quot;. Cheers, Andrew Mc >>> Thomas Baier <[EMAIL PROTECTED]> 12/08/2008 9:33 p.m. >>> Andrew, Andrew McLachlan schrieb: > Secondly, I am not sure how to use RExcelInstaller on CRAN. I have > downloaded and extracted RExcelInstaller_3.0-1.zip from my nearest CRAN > mirro

Re: [Rcom-l] Installing RExcel 3.0.1 and Visual Basic 400 error

t;> I have never seen this. Please tell us Windows and Excel versions. By the way: The right way to install is using the package RExcelInstaller on CRAN On Aug 10, 2008, at 10:50 PM, Andrew McLachlan wrote: > Hi All > > I have just downloaded the latest version of RExcel. &g

[Rcom-l] Installing RExcel 3.0.1 and Visual Basic 400 error

Any suggestions or help in tracking down this cryptic messagebox would be most appreciated. Cheers, Andrew Mc Andrew McLachlan, Biometrician Crop & Food Research, Palmerston North, New Zealand. Tel +64-6-356-8300, +64-6-355-6110 (DDI) Visit our website a

Re: [Rcom-l] Detecting if RExcel is installed

ED]> Function RExcelAvailable() As Boolean RExcelAvailable = AddinInstalledAndEnabled("RExcel.xla") or _ AddinInstalledAndEnabled("RExcel2007.xlam") End Function Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop & Food Research, Palmerston North, New

[Rcom-l] Detecting if RExcel is installed

Hi All Can anyone suggest to me ways of using VBA from within Excel to detect whether the RExcel add-in is installed or not? My first thought is perhaps to check for the presence of some RExcel constants, for example, RExcelVersion. Cheers, Andrew Mc Visit our website at http://www.crop.cri.nz

Re: [Rcom-l] RExcel and long Excel filenames

providing the error handling code. It is so obvious once it has been pointed out. :-) Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop & Food Research, Palmerston North, New Zealand. Tel +64-6-356-8300, +64-6-355-6110 (DDI) >>> On 14/07/2008 at 7:02 p.m., Erich Neuwirth <

Re: [Rcom-l] Background RExcel

I tried using: setservertype (stlocalforeground) in my macro code but that gave me an error message: "Compile error: Variable not defined" for "stlocalforeground" I don't know what else to try. Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop & Food Re

[Rcom-l] RExcel and long Excel filenames

rface.PutArray "x", rngX, False, False", how can I detect whether or not this has been successful? Any advice or information would be most appreciated. Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop & Food Research, Palmerston North, New Zealand. Tel +64-6-356-8300

[Rcom-l] RExcel questions here?

Hi All Just a short question. Is it okay to ask questions here on the use of RExcel, including VBA programming for RExcel? Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop & Food Research, Palmerston North, New Zealand. Tel +64-6-356-8300, +64-6-355-6110 (DDI) Visit our websit