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 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
