Where do I have to run the function? I am sorry, I am a new VBA and Rexcel user...
Regards René ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard M. Heiberger Sent: 22 October 2007 15:44 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] VBA - REcel error I am guessing that there is a registry glitch. Let us confirm that this is the problem you are seeing. Please run the following function on both your computers. My guess is that one of them will report [1] "\"C:\\Program Files\\R\\(D)COM Server\\xls\\RExcel.xla\"" and the other will report [1] "\"C:\\PROGRA~1\\R\\(D)COM Server\\xls\\RExcel.xla\"" There will also be some errors which you may ignore. Please pick up the entire output from this function on both machines and send it to the list. Erich has almost solved this problem. He will get back to you with a fix. The fix is non-trivial. Please wait for his repair. Rich RExcel.registry <- function(office="11.0") { Excel.Office.key <- paste("HKEY_CURRENT_USER\\Software\\Microsoft\\Office\\", office, "\\Excel\\Options <file:///\\Excel\Options> ", sep="") print(tcltk2::tk2reg.get(Excel.Office.key,"OPEN")) print(tcltk2::tk2reg.get(Excel.Office.key,"OPEN1")) print(tcltk2::tk2reg.get(Excel.Office.key,"OPEN2")) } RExcel.registry("10.0") ## Excel 2002 RExcel.registry("11.0") ## Excel 2003 RExcel.registry("12.0") ## Excel 2007
_______________________________________________ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at
