[R] R-Excel Macro Problem

[Yasir Kaheil]

glad to hear things worked out. 
y

nmarti wrote:
> 
> 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
>>> 
>> 
>> 
> 
> 


-----
Yasir H. Kaheil
Catchment Research Facility
The University of Western Ontario 

-- 
View this message in context: http://www.nabble.com/R-Excel-Macro-Problem-tp17450757p17462407.html
Sent from the R help mailing list archive at Nabble.com.