[R] R-Excel Macro Problem

[nmarti]

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.