Charles, thanks for the thought. In my case that's quite impractical/impossible because I'm working from a monstrous spreadsheet having dozens of sheets and numerous links. In some way that's the irreplaceable aspect of a spreadsheet program like Excel.
H. >>> "Charles Annis, P.E." <[EMAIL PROTECTED]> 6/1/2007 9:03:20 AM >>> You might consider having R do everything: R can read the Excel sheet, do what needs to be done, and write the results to an Excel sheet. Charles Annis, P.E. [EMAIL PROTECTED] phone: 561-352-9699 eFax: 614-455-3265 http://www.StatisticalEngineering.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Horace Tso Sent: Friday, June 01, 2007 11:51 AM To: r-help@stat.math.ethz.ch Subject: [R] Excel calling R functions 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 ______________________________________________ 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. ______________________________________________ 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.