In this case it is clear what happens.
Excel stores the complete absolute path of the addin.
This path is different on the 2 machines.
Remove the reference and addi it manually on the machine where things do
not work. Then changes are good that tings work again.
Rene Dreos (JIC) wrote:
> Hi, I run the functions and now it is clear that the differences between the
> two computers are on the OS language. The office computer that I used to
> develop the script is in English, rather then the home computer is in
> Italian...
>
> Here is the output of the office computer:
>> RExcel.registry("11.0") ## Excel 2003
> [1] "\"C:\\Program Files\\R\\(D)COM Server\\xls\\RExcel.xla\""
> Error in structure(.External("dotTcl", ..., PACKAGE = "tcltk"), class =
> "tclObj") :
> [tcl] unable to get value "OPEN1" from key
> "HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options": The system
> cannot find the file specified..
>
> Here is the home computer:
>> RExcel.registry("11.0") ## Excel 2003
> [1] "\"C:\\Programmi\\R\\(D)COM Server\\xls\\RExcel.xla\""
> Error in structure(.External("dotTcl", ..., PACKAGE = "tcltk"), class =
> "tclObj") :
> [tcl] unable to get value "OPEN1" from key
> "HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options": Impossibile
> trovare il file specificato..
>
> Regards
> René
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard M.
> Heiberger
> Sent: 22 October 2007 17:35
> To: R(D)COM and RExcel server related issues
> Subject: RE: [Rcom-l] VBA - REcel error
>
> In the R Console window.
> Pick up the function definition and the three lines beyond it
> in my first email and drop them into the R Console window.
> _______________________________________________
> 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
> _______________________________________________
> 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
>
>
_______________________________________________
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
