There are a few objects in vba for handling addins. If you search for "addin" in excel's vba help you will find all necessary details. Basically, you should be able to do something like this:
For ai in Application.addins if ai.name="RExcel" then found=true Next ai -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew McLachlan Sent: Thursday, July 17, 2008 05:51 To: rcom-l@mailman.csd.univie.ac.at Subject: [Rcom-l] Detecting if RExcel is installed Hi All Can anyone suggest to me ways of using VBA from within Excel to detect whether the RExcel add-in is installed or not? My first thought is perhaps to check for the presence of some RExcel constants, for example, RExcelVersion. Cheers, Andrew Mc Visit our website at http://www.crop.cri.nz ______________________________________________________ CAUTION: The information contained in this email is privileged and confidential. If you read this message and you are not the intended recipient, you are hereby notified that any use, dissemination, distribution or reproduction of all or part of the contents is prohibited. If you receive this message in error, please notify the sender immediately. Any opinions or views expressed in this message are those of the individual sender and may not represent those of their employer. _______________________________________________ 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 DISCLAIMER: L'utilizzo non autorizzato del presente messaggio รจ vietato e potrebbe costituire reato. Le informazioni e le opinioni contenute in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. _______________________________________________ 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