Dear R Users, I am having trouble using R from within Excel. I've installed R(D) Com Client and then try to open up the first sample sheet.
As Excel executes auto_open, it stops at function "ExcelVersionMajor" and complaines that a certain type library is missing: missing rcom 1.0 type library It appears to be looking for this in the wrong directory: C:\Progra~2\R\R-24~11\library\rcom\libs\rcom_srv.tlb I am currently using R2.6.0 which is located in Program Files\R\R-2.6.0 The library it is looking for is in a subdirectory there in library\rcom\libs When I link in that library through the References dialog box in VBA and rerun Auto_Open, that version of Excel works fine. However, if I close down that Excel and reopen, I get the same problem an have to relink. I looking at the Environment Variables under System in Control Panel but there is nothing there which refers to either of the two directories. How can I fix this problem ? My version of Excel is Excel 2002 SP3 and version of Windows is XP Professional SP2. Thanks, Tolga ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.