Thanks to Marc, Duncan, Tobias, Alberto. I'm aware of rcom and have in fact downloaded it somewhere. But unfortunately it won't work for me as I'm in a corporate environment and don't have admin rights to set up the R(D)COM (background) server. If there is a way to work around it, pls let me know.
Horace >>> Duncan Temple Lang <[EMAIL PROTECTED]> 6/1/2007 11:27:35 AM >>> And just for completeness for the thread, there is the RDCOMServer package which has a more general mechanism for making R functionality available to other applications that does not require writing R commands but uses the language independent spirit of DCOM. And it also allows event handlers for things like Excel actions to be written as R functions Tobias Verbeke wrote: > Marc Schwartz wrote: >> On Fri, 2007-06-01 at 08:50 -0700, Horace Tso wrote: >>> Hi folks, >>> >>> Is it possible to have Excel call a R function. If not, how about >>> making Excel send off a command to call a R script and then read the >>> result back into Excel. >>> >>> I know, I know, this should belong to some Excel forum, but i just try >>> my luck here. >>> >>> Thanks in advance. >>> >>> Horace W. Tso >> >> See the R-Excel add-in linked from here: >> >> http://www.sciviews.org/_rgui/projects/RDcom.html >> > > Some of the files listed in the link on that page appear > to be quite outdated. The following link brings you to > the current portal of the R(D)COM server and the > rcom package. > > http://sunsite.univie.ac.at/rcom/ > > See the Excel heading for your question. You might be > interested as well by the recent OpenOffice.org plugin > (heading OOo). > > HTH, > Tobias > -- Duncan Temple Lang [EMAIL PROTECTED] Department of Statistics work: (530) 752-4782 4210 Mathematical Sciences Bldg. fax: (530) 752-7099 One Shields Ave. University of California at Davis Davis, CA 95616, USA ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.