Hi,
I need help trying to read a list box value and an option button
selection into R. My code should then use these two variables and
compute the rest of the results and display in VBA. Right now, I am
displaying these two values in a cell in Excel and reading it into R,
but then when the user
Hi,
I am having a problem reading data between R and Excel.
I have saved my code in file: lastsave.txt, and am trying to execute the
R commands when the user clicks the command button PA in Excel VBA. I
also let the user choose a date (using list box) and one of three
options using an optio
e line
Portfolio = read.csv("c:\\work\\Portfolio.csv", header = T)
works on my machine when i put things in c:\work
Uma Sitaraman wrote:
> Hi,
>
> I tried to choose the foreground option in Set R server and configure
R
> but then it gives me the error "R Server not avail
e program did not execute sample.R because it could not find it.
To debug:
Use rcom (not (D)COM and make the window visible.
Single step through your VBA code using F8 and
Shift-F8. After running sample.R switch to the R Gui and
check of your dataframe really exists.
Uma Sitaraman wrote:
> Hi,
>
e same error.
I am using R (2.5.1) and RSrv200.exe.
Regards,
Uma
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Uma
Sitaraman
Sent: Wednesday, January 23, 2008 9:52 AM
To: R (D)COM and RExcel server related issues
Subject:
] Read Excel data
Uma Sitaraman wrote:
> Hi,
>
>
>
> I am new to both R and RDcom, and am stuck trying to read excel data
> using R (through VBA code). I tried out the test code posted in the
web
> (given below)
>
>
>
> Sub ReadTest()
Hi,
I am new to both R and RDcom, and am stuck trying to read excel data
using R (through VBA code). I tried out the test code posted in the web
(given below)
Sub ReadTest()
> rinterface.StartRServer
> rinterface.RRun "setwd(""c:/work/rcomtest"")"
> ChDir "c:\work\rcomtest"
>