Re: [R] R-Excel Macro Problem

From: Yasir Kaheil <>
Date: Sun, 25 May 2008 14:09:37 -0700 (PDT)

glad to hear things worked out.

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:
Sent from the R help mailing list archive at

______________________________________________ mailing list
PLEASE do read the posting guide
and provide commented, minimal, self-contained, reproducible code.
Received on Sun 25 May 2008 - 21:22:11 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 - 22:30:45 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.

list of date sections of archive