Hi Bert, My_R as well as Rconnected is a variable defined in the Rinterface module of Rexcel.xla. When you open the VBA editor in excel, then you will see that there is a VBA project called RexcelVBAlib, provided that the Rexcel addin is installed. To reference this variables you need to add a reference to your project to RexcelVBAlib. You can do it from the menu of VBA editor: Tools->References.
Vilmos > Hi Vilmos, > > Where does the My_R stands for in the expression: RExcelVBAlib.My_R > Is this a reference to a dll or something else? > Thx for complementing our logo. > Bert > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: 22 September 2008 13:01 > To: rcom-l@mailman.csd.univie.ac.at > Subject: Rcom-l Digest, Vol 43, Issue 16 > > Send Rcom-l mailing list submissions to > rcom-l@mailman.csd.univie.ac.at > > To subscribe or unsubscribe via the World Wide Web, visit > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > or, via email, send a message with subject or body 'help' to > [EMAIL PROTECTED] > > You can reach the person managing the list at > [EMAIL PROTECTED] > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Rcom-l digest..." > > > Today's Topics: > > 1. Check if R is running (Bert Jacobs) > 2. Re: Check if R is running (Vilmos Prokaj) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Mon, 22 Sep 2008 12:41:12 +0200 > From: "Bert Jacobs" <[EMAIL PROTECTED]> > Subject: [Rcom-l] Check if R is running > To: <rcom-l@mailman.csd.univie.ac.at> > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > Skipped content of type multipart/alternative-------------- next part > -------------- > A non-text attachment was scrubbed... > Name: not available > Type: image/jpeg > Size: 16622 bytes > Desc: not available > Url : > http://mailman.csd.univie.ac.at/pipermail/rcom-l/attachments/20080922/8c60d1 > 5f/attachment-0001.jpe > > ------------------------------ > > Message: 2 > Date: Mon, 22 Sep 2008 13:00:50 +0200 (CEST) > From: "Vilmos Prokaj" <[EMAIL PROTECTED]> > Subject: Re: [Rcom-l] Check if R is running > To: "R \(D\)COM and RExcel server related issues" > <rcom-l@mailman.csd.univie.ac.at> > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain;charset=iso-8859-15 > > Hi, > > You can create a reference to the rexcelvbalib project (this is the > Rxcel.xla) and after this you can use e.g. something similar to this > > Sub chkR() > If RExcelVBAlib.RConnected And Not (RExcelVBAlib.My_R Is Nothing) Then > MsgBox "R is running" > Else > MsgBox "R is not running" > End If > End Sub > > By the way your logo is very nice. > > Vilmos > >> >> >> Hi, >> >> Just a little question: >> >> Is there a way to check whether R is running in the background with vba. >> >> I know that when R is running in the background, that on the RExcel Menu >> I >> can chose RClose and if R is not running I can chose RStart, but is >> there >> a >> way to check this with VBA. >> >> Thx, >> >> Bert >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> 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 > > > -- > Vilmos Prokaj > Evtvvs Lorand University, > Department of Probability and Statistics > Pazmany Piter sitany 1/C > Budapest, 1117 > Hungary > > e-mail:[EMAIL PROTECTED] > > > > ------------------------------ > > _______________________________________________ > Rcom-l mailing list > Rcom-l@mailman.csd.univie.ac.at > http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l > > > End of Rcom-l Digest, Vol 43, Issue 16 > ************************************** > > _______________________________________________ > 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 > -- Vilmos Prokaj Eötvös Loránd University, Department of Probability and Statistics Pázmány Péter sétány 1/C Budapest, 1117 Hungary e-mail:[EMAIL PROTECTED] _______________________________________________ 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
