D(COM) with Excel
On Mon, 26 Jan 2004, Joel Pitt wrote:
Hi there, I'm currently trying to use R in an automated macro with Excel, and to this effect I've been using the D(COM) server. However I've been having alot of problems with it, because it seems to be limited to only recieving and sending arrays. I've been struggling trying to find a way to receive model summaries from R to put in Excel. I also seem to have some strange errors coming up... I've tried doing everything I want directly in R by hand, and it has been fine, but excel seems to complicate everything :( Any people have suggestions?
There are two (D)COM servers for R, on by Thomas Baier that has its own mailing list, and one by Duncan Temple Lang (at www.omegahat.org and in the Omegahat area on CRAN). It is impossible for us to help with a message as vague as `some strange errors coming up', so I suggest you read http://www.chiark.greenend.org.uk/~sgtatham/bugs.html and then post on the appropriate mailing list for whichever server you are using. [The Baier-version list is listed at the bottom of its readme.txt file.]
Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595