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
code = "source('c://global//source//admin//porto.r' )"
Call rinterface.RRun(code)
End Sub
------------------------------------------------------------------------
*From:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of *Krishanu
Saha
*Sent:* 21 July 2008 06:34
*To:* rcom-l@mailman.csd.univie.ac.at
*Subject:* [Rcom-l] Problem in calling R in Excel
Hi everybody,
I am new to R-excel-add in and trying to connect my R code with excel.
My R version is 2.5.1 and the R (D)com is V 2.01.
The code I am using to call R is
Call RInterface.RRun("source(""" & Replace(ThisWorkbook.Path, "\", "/")
& "/PORTO"")") , where PORTO is the R source file containing my code.
Please help me sort the problem. Thank you all.
Regards,
Krishanu Saha
* *
This e-mail may contain confidential and/or privileged information. If you are
not the intended recipient (or have received this
e-mail in error) please notify the sender immediately and destroy this e-mail.
Any unauthorized copying, disclosure or distribution of
the material in this e-mail is strictly forbidden. Any views or opinions
presented are solely those of the author and do not
necessarily represent those of Amba Holdings Inc., and/or its affiliates.
Important additional terms relating to this email can be obtained
at http://www.ambaresearch.com/disclaimer
**********************************************************
The information provided in this e-mail is confidential and is for the
sole use of the recipient. It may not be disclosed, copied or
distributed in any form without the express permission of Henderson
Global Investors and to the extent that it is passed on, care must be
taken to ensure that this is in a form which accurately reflects the
information presented here.
Whilst Henderson Global Investors believe that the information is
correct at the date of this e-mail, no warranty or representation is
given to this effect and no responsibility can be accepted by Henderson
Global Investors to any end users for any action taken on the basis of
this information.
Henderson Global Investors is the name under which Henderson Global
Investors Limited (registered no. 906355), Henderson Fund Management plc
(registered no. 2607112), Henderson Investment Funds Limited (registered
no. 2678531), Henderson Investment Management Limited (registered no.
1795354) Henderson Alternative Investment Advisor Limited (registered
no. 962757) and Henderson Equity Partners Limited (registered
no.2606646) (each incorporated and registered in England and Wales with
registered office at 4 Broadgate, London EC2M 2DA and authorised and
regulated by the Financial Services Authority) provide investment
products and services. Henderson Secretarial Services Limited
(incorporated and registered in England and Wales, registered no.
1471624, registered office 4 Broadgate, London EC2M 2DA) is the name
under which company secretarial services are provided. All these
companies are wholly owned subsidiaries of Henderson Group plc
(incorporated and registered in England and Wales, registered no.
2072534, registered office 4 Broadgate, London EC2M 2DA).
We may record telephone calls or email for our mutual protection and to
improve customer service.
**********************************************************
------------------------------------------------------------------------
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
--
Erich Neuwirth, University of Vienna
Faculty of Computer Science
Computer Supported Didactics Working Group
Visit our SunSITE at http://sunsite.univie.ac.at
Phone: +43-1-4277-39464 Fax: +43-1-4277-39459
_______________________________________________
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l
More information (including a Wiki) at http://rcom.univie.ac.at
