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
