That works! Thank you so much for your help.
Erich Neuwirth <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/20/07 11:52 AM
Please respond to
"R \(D\)COM and RExcel server related issues"
To
"R (D)COM and RExcel server related issues"
cc
Subject
Re: [Rcom-l] GetArrayToVBA
Try
Try
Dim metricSurface As Variant
Without the parentheses.
Ryan Sheftel wrote:
>
> I am trying to use the GetArrayToVBA for a large dataframe in R into
> Excel VBA.
>
> In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data
> frame.
>
> I use the following in VBA t
metricSurface is
Excel: v2003 (11.8146.8132) SP2
RXcel: v 1.75 (20070308)
metricSurface has character names for the columns, and either numerical or
boolean values. I though that wrapping in the "as.matrix" would coerce to
numeric.
Erich Neuwirth <[EMAIL PROTECTED]>
Sent by: [EMAIL PRO
What kind of data does metricSurface contain?
What versions or R and RExcel are you using?
Ryan Sheftel wrote:
>
> I am trying to use the GetArrayToVBA for a large dataframe in R into
> Excel VBA.
>
> In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data
> frame.
>
> I use th
I am trying to use the GetArrayToVBA for a large dataframe in R into Excel
VBA.
In R the dataframe "metricSurface" is a large (12 cols, 32760 rows) data
frame.
I use the following in VBA to retrieve it:
Dim metricSurface() As Variant
metricSurface =
rinterface.GetArrayToVBA("a
Hello, thank you very much for your reply. I saved my codes of defining the
functions I need as a file named RExcelStartup.R in the same directory as the
Excel sheet I am working on. But when I call the function, the following error
message comes out in the R Console
Error in eval(expr, envir, e
Excellent that works!!
Thanks for the help.
Wayne
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Erich
Neuwirth
Sent: 20 November 2007 09:13
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] Example exporting R graph to Powerpoint
Th
This code works.
ppt<-comCreateObject("Powerpoint.Application")
comSetProperty(ppt,"Visible",TRUE)
myPresColl<-comGetProperty(ppt,"Presentations")
myPres<-comInvoke(myPresColl,"Add")
mySlides<-comGetProperty(myPres,"Slides")
mySlide<-comInvoke(mySlides,"Add",1,12)
myShapes<-comGetProperty(mySlide,
