<div>
Set colProcesses = objWMIService.ExecQuery _<br />
&nbsp; (&quot;Select * from Win32_Process Where Name = '&quot; &amp;&nbsp; MYPROGRAM &amp;&nbsp;&quot;'&quot;)<br />
<br />
should do it...
</div>


Set colProcesses = objWMIService.ExecQuery _
  ("Select * from Win32_Process Where Name = '" &  MYPROGRAM & "'")

should do it...

<div>
Shouldn't have typed &quot;should do it...&quot; <br />
:^ )
</div>


Shouldn't have typed "should do it..."
:^ )

<div>
You guys are Great! &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
<br />
In the vbscript below, i'm trying to see if I can substitute a variable in the select statement below. &nbsp;I haven't been able to make it work. &nbsp;Does anyone know a way?<br />
<br />
Thanks<br />
Randy<br />
--------------------------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />----------<wbr />-----<br />
strComputer = &quot;.&quot;<br />
<br />
Dim myprogram<br />
MYPROGRAM = &quot;outlook.exe&quot; &nbsp;&lt;&lt;&lt;&lt;&lt;&lt;&lt;THIS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
<br />
<br />
Set objWMIService = GetObject(&quot;winmgmts:&quot; _<br />
&nbsp; &nbsp; &amp;&nbsp;&quot;{impersonationLevel=imper<wbr />sonate}!\\<wbr />&quot; &amp;&nbsp;strComputer &amp;&nbsp;&quot;\root\cimv2&quot;)<br />
Set colProcesses = objWMIService.ExecQuery _<br />
&nbsp; &nbsp; (&quot;Select * from Win32_Process Where Name = MYPROGRAM&quot;) &lt;&lt;&lt;&lt;&lt;&lt;&lt;THIS<br />

</div>
</div>



In the vbscript below, i'm trying to see if I can substitute a variable in the select statement below.  I haven't been able to make it work.  Does anyone know a way?

Thanks
Randy
-----------------------------------------------------------------------------------------------------
strComputer = "."

Dim myprogram
MYPROGRAM = "outlook.exe"  <<<<<<<THIS          


Set objWMIService = GetObject("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colProcesses = objWMIService.ExecQuery _
    ("Select * from Win32_Process Where Name = MYPROGRAM") <<<<<<<THIS


vbscript select * using a variable in a select statement

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,