[R] Using (D)COM in Excel
Amy C. Peng
apeng at emmes.com
Tue Jan 25 03:52:53 CET 2000
Dear Fellow R-Users:
I am trying to install the (D)COM server, version 0.91. I followed the
installation instructions all the way through the command lines
and everything so far seemed okay. Then I logged out, and ran
bin\vbtest.exe, and everything still seemed fine (it gave me a plot of a
Then I went into Excel97, and I wrote the following macro into a module:
Dim x As StatConnector
Set x = New StatConnector
On Error GoTo Error_Handler
MsgBox x.GetErrorText, "R Server Error"
and I got a compiler error message that says that the StatConnector
user-defined type is not defined.
Does anybody know how I should go about defining the user-defined type
StatConnector? Am I missing a step somewhere? I thought maybe that by
registering it using the regsvr32 command that somehow I've "defined" it as
a type recognizable by Microsoft, but I am not sure.
Thanks for your help!
The EMMES Corporation
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch
More information about the R-help