Re: [R] rcom package - Events

2012-01-07 Thread Uwe Ligges
On 07.01.2012 15:02, AAsk wrote: I have downloaded the PDF/manual for rcom from http://cran.us.r-project.org/web/packages/rcom/index.html. Unfortunately, this guide does not cover the topic of setting event handlers for Excel (COM Server). Can someone provide me with some clues - either code

[R] rcom package - Events

2012-01-07 Thread AAsk
I have downloaded the PDF/manual for rcom from http://cran.us.r-project.org/web/packages/rcom/index.html. Unfortunately, this guide does not cover the topic of setting event handlers for Excel (COM Server). Can someone provide me with some clues - either code or a url which will help me do this?

Re: [R] rcom package

2010-03-09 Thread Albert-Jan Roskam
--- On Tue, 3/9/10, Erich Neuwirth wrote: From: Erich Neuwirth Subject: Re: [R] rcom package To: r-help@r-project.org Date: Tuesday, March 9, 2010, 5:28 PM rcom allows you to access the full object model of any COM server. The object browser in Excel allows you to investigate Excel's object

Re: [R] rcom package

2010-03-09 Thread Erich Neuwirth
rcom allows you to access the full object model of any COM server. The object browser in Excel allows you to investigate Excel's object model. It also tells you which properties are accessible. There are a few hundreds of them. On 3/9/2010 4:35 PM, Albert-Jan Roskam wrote: > Hi, > > I would

Re: [R] rcom package

2010-03-09 Thread Gabor Grothendieck
If you just want to read tabular data from Excel then there are many options in R: http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows On Tue, Mar 9, 2010 at 10:35 AM, Albert-Jan Roskam wrote: > Hi, > > I would like to make a program that reads excel files, and writes the cells > of wh

[R] rcom package

2010-03-09 Thread Albert-Jan Roskam
Hi,   I would like to make a program that reads excel files, and writes the cells of which contents is not a formula to another file. I don't think this is possible with RODBC, but it may be possible with rcom.     I read the documentation of the rcom package, but I was hoping somebody knows a g

[R] Rcom package

2008-01-24 Thread Uma Sitaraman
Hi, I have R 2.5.1 installed in my system and have installed rcom package 1.5-2.2 vesion. I don't see the following reference "RCOM 1.0 Type Library" in the VBA IDE. Please help. Also, after installing when I type comRegisterRegistry(), it return "NULL". Is that ok? Same with comRegisterServer