Hello ronjon65,
If your running VBA in Office 2003, which is VBA6, then you only need the code below:
These lines of code will only compile in VBA7:' 32 bit API Private Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long Private Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
Note: The following words PtrSafe and LongPtr are part of VBA7 only and will not compile in earlier versions of VBA.
' 64 Bit API Private Declare PtrSafe Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As LongPtr Private Declare PtrSafe Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As LongPtr, lpExitCode As Long) As Long




Reply With Quote