Re: [R] R-Excel Macro Problem

From: nmarti <nate318i_at_yahoo.com>
Date: Sun, 25 May 2008 10:55:39 -0700 (PDT)

Ok, so I'm embarrassed to admit I made a really dumb mistake. My VBA page was declared as "Sheet1" code when it should have been "Module1" code. I knew it was something stupid. Sorry for the inconvenience.

Yasir Kaheil wrote:

> 
> hi Nate,
> could you please email me your excel workbook. thanks
> y
> 
> nmarti wrote:

>>
>> I'm trying to write R functions into VBA code. I've done this many other
>> times in other documents and everything has run great. But today I keep
>> recieving an error message "Run-time error '1004': Application-defined or
>> object-defined error."
>>
>> Has anyone else encountered this same error message?
>>
>> I do not recieve this error in the document when running regular VBA
>> code. But when I try to run,
>> Call Rinterface.PutDataframe("Data", Range("Sheet1!A1:E2000"))
>> I receive the error.
>> I have the VBA "References" RExcelVBAlib checked.
>>
>> Any suggestions would be appreiciated,
>> Nate
>>
>
>
-- 
View this message in context: http://www.nabble.com/R-Excel-Macro-Problem-tp17450757p17460474.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_r-project.org 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.
Received on Sun 25 May 2008 - 21:34:47 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Sun 25 May 2008 - 23:30:40 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive