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