R help - Aug 2009 - RE xcel - two problems - Running RExcel & Working Directory error

Hi,

I am using RExcel both at work and at home and am facing a couple of
challenges. The one at home is that when using RExcel and trying to run any
code that involves changing the working directory, I get the following
error. 

Error in command: 
setwd("C:\\Raoul\\R\\R Maps_UK
Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n
  cannot change working directory

The one at office is more complicated, I have had R,RExcel & the DCOM
package installed and re-installed numerous times but still get the error
"there is no R server connected to Excel" and when I try to set the
server
it does not work.

Could someone please help me out with these problems?

Thanks in advance,
Raoul
-- 
View this message in context:
http://www.nabble.com/RExcel---two-problems---Running-RExcel---Working-Directory-error-tp25217926p25217926.html
Sent from the R help mailing list archive at Nabble.com.

1. The embedded blanks often cause problems.  Try the 8.3 version of the 
filepath.  To find the 8.3 name, open an MSDOS cmd window and enter
"dir /x 'C:\\Raoul\\R"
There will be a line something like
RMAPS_~1  R Maps_UK Maps_Test

Use the value that appears in the RMAPS_~1 position.

2. try loading rcom at the R prompt before starting RExcel from the
Excel window.

require(rcom)

If that works you will need to modify your Rprofile to make that happen 
automatically.


Further questions on RExcel should be sent to the rcom mailing list
rcom-l at mailman.csd.univie.ac.at
If you need further help, please include the information from RExcel:
In Excel, click on RExcel > About RExcel > Copy to Clipboard > OK
Then move to your email and paste that information.

Rich