Solved

Check if process is running from VBA

Posted on 2003-12-04
12
427 Views
Last Modified: 2007-12-19
Hi,  I am using the Shell command to run an external application from an MSACCESS app, and need to be able to check if there is an instance of the program running in memory already.  Any ideas, please?

Thanks!

Terran
0
Comment
Question by:earthman100
  • 7
  • 5
12 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 9883376
you could do a getobject("....")  and see if you get anything

Dim vobj As Object
Set vobj = GetObject("...")
If vobj Is Nothing Then
   'instance not running
End If

I bet there are api calls that coudl do this faster ... have you looked in the VB section?

Steve
0
 

Author Comment

by:earthman100
ID: 9884866
I haven't looked there, perhaps I should delete this post and post it there?  I have had difficulties with trying VB scripts in VBA before.

I will try you get object idea first...
0
 

Author Comment

by:earthman100
ID: 9911150
I get an error:

"File name or class name not found during Automation operation (Error 432)"

when using:

Dim vobj As Object
Set vobj = GetObject("C:\Program Files\UltraVNC\WinVNC.exe")
If vobj Is Nothing Then
   Shell """C:\Program Files\UltraVNC\WinVNC.exe"""
End If

0
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 
LVL 39

Expert Comment

by:stevbe
ID: 9911704
hmmm .... looks like WinVNC is not an automation server so you will need to iterate all open windows on the PC ... here is some code that shows you how to that ...

http://www.mvps.org/access/api/api0007.htm

Steve
0
 

Author Comment

by:earthman100
ID: 10072685
Actually it is not an open window, just a process.  Any ideas?

Terran
0
 
LVL 39

Expert Comment

by:stevbe
ID: 10072920
what happens if you launch (or try) another instance?

Shell ...
Runs an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero.

varRet = Shell """C:\Program Files\UltraVNC\WinVNC.exe"""

and depending on what varret gives you ???

Steve
0
 

Author Comment

by:earthman100
ID: 10074777
I will try that and get back to you
0
 

Author Comment

by:earthman100
ID: 10133623
I get different numbers each time, plus it runs the application regardless.  

I want to check if the process is running without running it.

Thanks for your suggestions so far, any others?

0
 
LVL 39

Accepted Solution

by:
stevbe earned 50 total points
ID: 10136723
0
 

Author Comment

by:earthman100
ID: 10138063
Thanks Stevbe,

I used the one at:

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20684555.html

and altered it as below in a module. When I call the function "getVNC" it returns True if the process is running.  

Thanks for your help.  Much appreciated!

#############################################

Option Explicit
      Public Declare Function Process32First Lib "kernel32" ( _
         ByVal hSnapshot As Long, lppe As PROCESSENTRY32) As Long

      Public Declare Function Process32Next Lib "kernel32" ( _
         ByVal hSnapshot As Long, lppe As PROCESSENTRY32) As Long

      Public Declare Function CloseHandle Lib "Kernel32.dll" _
         (ByVal Handle As Long) As Long

      Public Declare Function OpenProcess Lib "Kernel32.dll" _
        (ByVal dwDesiredAccessas As Long, ByVal bInheritHandle As Long, _
            ByVal dwProcId As Long) As Long

      Public Declare Function EnumProcesses Lib "psapi.dll" _
         (ByRef lpidProcess As Long, ByVal cb As Long, _
            ByRef cbNeeded As Long) As Long

      Public Declare Function GetModuleFileNameExA Lib "psapi.dll" _
         (ByVal hProcess As Long, ByVal hModule As Long, _
            ByVal ModuleName As String, ByVal nSize As Long) As Long

      Public Declare Function EnumProcessModules Lib "psapi.dll" _
         (ByVal hProcess As Long, ByRef lphModule As Long, _
            ByVal cb As Long, ByRef cbNeeded As Long) As Long

      Public Declare Function CreateToolhelp32Snapshot Lib "kernel32" ( _
         ByVal dwFlags As Long, ByVal th32ProcessID As Long) As Long

      Public Declare Function GetVersionExA Lib "kernel32" _
         (lpVersionInformation As OSVERSIONINFO) As Integer

      Public Type PROCESSENTRY32
         dwSize As Long
         cntUsage As Long
         th32ProcessID As Long           ' This process
         th32DefaultHeapID As Long
         th32ModuleID As Long            ' Associated exe
         cntThreads As Long
         th32ParentProcessID As Long     ' This process's parent process
         pcPriClassBase As Long          ' Base priority of process threads
         dwFlags As Long
         szExeFile As String * 260       ' MAX_PATH
      End Type

      Public Type OSVERSIONINFO
         dwOSVersionInfoSize As Long
         dwMajorVersion As Long
         dwMinorVersion As Long
         dwBuildNumber As Long
         dwPlatformId As Long           '1 = Windows 95.
                                        '2 = Windows NT

         szCSDVersion As String * 128
      End Type

      Public Const PROCESS_QUERY_INFORMATION = 1024
      Public Const PROCESS_VM_READ = 16
      Public Const MAX_PATH = 260
      Public Const STANDARD_RIGHTS_REQUIRED = &HF0000
      Public Const SYNCHRONIZE = &H100000
      'STANDARD_RIGHTS_REQUIRED Or SYNCHRONIZE Or &HFFF
      Public Const PROCESS_ALL_ACCESS = &H1F0FFF
      Public Const TH32CS_SNAPPROCESS = &H2&
      Public Const hNull = 0

      Public Function getVNC()
     
      Select Case getVers()

      Case 1 'Windows 95/98

         Dim f As Long, sname As String
         Dim hSnap As Long, proc As PROCESSENTRY32
         hSnap = CreateToolhelp32Snapshot(TH32CS_SNAPPROCESS, 0)
         If hSnap = hNull Then Exit Function
         proc.dwSize = Len(proc)
         ' Iterate through the processes
         f = Process32First(hSnap, proc)
         Do While f
           sname = StrZToStr(proc.szExeFile)
           Debug.Print sname
           f = Process32Next(hSnap, proc)
         Loop

      Case 2 'Windows NT

         Dim cb As Long
         Dim cbNeeded As Long
         Dim NumElements As Long
         Dim ProcessIDs() As Long
         Dim cbNeeded2 As Long
         Dim NumElements2 As Long
         Dim Modules(1 To 200) As Long
         Dim lRet As Long
         Dim ModuleName As String
         Dim nSize As Long
         Dim hProcess As Long
         Dim i As Long
         'Get the array containing the process id's for each process object
         cb = 8
         cbNeeded = 96
         Do While cb <= cbNeeded
            cb = cb * 2
            ReDim ProcessIDs(cb / 4) As Long
            lRet = EnumProcesses(ProcessIDs(1), cb, cbNeeded)
         Loop
         NumElements = cbNeeded / 4

         For i = 1 To NumElements
            'Get a handle to the Process
            hProcess = OpenProcess(PROCESS_QUERY_INFORMATION _
               Or PROCESS_VM_READ, 0, ProcessIDs(i))
            'Got a Process handle
            If hProcess <> 0 Then
                'Get an array of the module handles for the specified
                'process
                lRet = EnumProcessModules(hProcess, Modules(1), 200, _
                                             cbNeeded2)
                'If the Module Array is retrieved, Get the ModuleFileName
                If lRet <> 0 Then
                   ModuleName = Space(MAX_PATH)
                   nSize = 500
                   lRet = GetModuleFileNameExA(hProcess, Modules(1), _
                                   ModuleName, nSize)
                    If InStr(1, Left(ModuleName, lRet), "WinVNC.exe") > 0 Then
                        Debug.Print Left(ModuleName, lRet)
                        getVNC = True
                    End If
                End If
            End If
          'Close the handle to the process
         lRet = CloseHandle(hProcess)
         Next

      End Select
      End Function



      Function StrZToStr(s As String) As String
         StrZToStr = Left$(s, Len(s) - 1)
      End Function

      Public Function getVers() As Long
         Dim osinfo As OSVERSIONINFO
         Dim retvalue As Integer
         osinfo.dwOSVersionInfoSize = 148
         osinfo.szCSDVersion = Space$(128)
         retvalue = GetVersionExA(osinfo)
         getVers = osinfo.dwPlatformId
      End Function

0
 
LVL 39

Expert Comment

by:stevbe
ID: 10147538
you are welcome, glad I could help, good luck with your project.
0
 

Author Comment

by:earthman100
ID: 10149469
Thanks, I appreciate that!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question