Gary,
You're totally right, we have to use 4 backslashes to obtain 2 backslashes
in a .NET string.
In VBA, you don't need to double the backslashes, so 2 is enough.
So Felipe, I think you can try any of these 3 solutions:
Call RRun("source(""" & Replace(ThisWorkbook.Path,"\","\\") &
"\\temp.r"")")
or RInterface.RunRFile ThisWorkbook.Path & "\temp.r"
as said by Yaning
or RRun "source(""" & Replace(ThisWorkbook.Path,"\","/") & "/temp.r"")"
as proposed by Erich
Regards
--
Julien Vanwinsberghe
Director, Statistical Solutions.
Clinbay (Statistical Solution to Drug Development)
www.clinbay.com
-----Message d'origine-----
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] De la part de Gary Prothero
Envoyé : lundi 17 décembre 2007 21:44
À : 'R (D)COM and RExcel server related issues'
Objet : RE: [Rcom-l] Call rinterface.RRun("Source(ThisWorkbook.Path &
Julien,
I my .net class I use 4 backslashes \\\\ when referencing a directory
location.
Gary Prothero
ProWorks Corporation
[EMAIL PROTECTED]
www.proworks.com
(541) 752-9885 ext. 1001
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Felipe
Carrillo
Sent: Monday, December 17, 2007 12:12 PM
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] Call rinterface.RRun("Source(ThisWorkbook.Path &
Hi all:
I tried double forward and backslashes and nothing
seems to work. I looked all over for an example using
ThisWorkbook.Path but couldn't find anything.Everybody
seems to use a hardcoded path to the R file. I wonder
if someone has another suggestion on how to run the R
file through VBA. Thanks
--- Julien Vanwinsberghe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> In addition, be careful with the "source" R
> function, all the folder
> separators '\' characters must be replaced by '\\'
> or '/'.
>
> Regards,
>
> Julien Vanwinsberghe
>
> Yaning Zhang a écrit :
> > Hi, if you would like to run R script from a file,
> maybe you can try
> > Call Rinterface.RunRFile
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED]
> On Behalf Of Felipe
> > Carrillo
> > Sent: Monday, December 17, 2007 3:35 PM
> > To: rcom-l@mailman.csd.univie.ac.at
> > Subject: Re: [Rcom-l] Call
> rinterface.RRun("Source(ThisWorkbook.Path &
> >
> > My R script and my workbook reside on my desktop.
> When
> > I try to run my script through the macro nothing
> > happens. the code below seems to be correct
> though.
> > Call rinterface.RRun("source("""&
> ThisWorkbook.Path
> > & "\temp.r"")")
> > Any ideas anybody?
> >
> >
> > --- Prokaj Vilmos <[EMAIL PROTECTED]> wrote:
> >
> >
> >> You probably wanted to write
> >>
> >> Call rinterface.RRun("source("""&
> ThisWorkbook.Path
> >> & "\temp.r"")")
> >>
> >> In VBA "" stands for " inside a string
> >>
> >> Vilmos Prokaj
> >>
> >>
> >
>
________________________________________________________________________
> > ____________
> >
> >>> Never miss a thing. Make Yahoo your home page.
> >>> http://www.yahoo.com/r/hs
> >>> _______________________________________________
> >>> 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
> >>
> >>>
> >>>
> >> _______________________________________________
> >> 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
> >>
> >>
> >
> >
> > Felipe D. Carrillo
> > Fishery Biologist
> > US Fish & Wildlife Service
> > California, USA
> >
> >
> >
> >
> >
>
________________________________________________________________________
> > ____________
> > Be a better friend, newshound, and
> > know-it-all with Yahoo! Mobile. Try it now.
> >
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
> >
> > _______________________________________________
> > 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
> > _______________________________________________
> > 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
> >
> >
>
>
> > _______________________________________________
> 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
Felipe D. Carrillo
Fishery Biologist
US Fish & Wildlife Service
California, USA
____________________________________________________________________________
________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
