Userform and .exe

[stapuff]

Is there a way to call and show an .exe on a userform?

I am looking to have a userform with a button that when clicked will show the .exe on top of the userform.

I currently have a worksheet with a button on it....that when it is clicked will open up the .exe The .exe will open but it is not on top of the spreadsheet.

Thanks

stapuff

 

[Jaafar Tribak]

Is there a way to call and show an .exe on a userform?

I am looking to have a userform with a button that when clicked will show the .exe on top of the userform.

I currently have a worksheet with a button on it....that when it is clicked will open up the .exe The .exe will open but it is not on top of the spreadsheet.

Thanks

stapuff

What code do you have ?

 

[stapuff]

Public Declare Function GetExitCodeProcess Lib "kernel32" (ByVal hProcess As Long, lpExitCode As Long) As Long
Public Declare Function OpenProcess Lib "kernel32" (ByVal dwDesiredAccess As Long, ByVal bInheritHandle As Long, ByVal dwProcessId As Long) As Long

Public Const STILL_ACTIVE = &H103
Public Const PROCESS_QUERY_INFORMATION = &H400


Sub Button1_Click()

'--- Some VBA Code here

sCmd = "C:\path to file.exe"
vntResult = OpenProcess(PROCESS_QUERY_INFORMATION, False, Shell(sCmd, vbNormalFocus))
GetExitCodeProcess vntResult, lngExitCode

' -----------------------------------------------------------
' Coded by Shasur for http://vbadud.blogspot.com
' -----------------------------------------------------------

Do
GetExitCodeProcess vntResult, lngExitCode
DoEvents
Loop While lngExitCode = STILL_ACTIVE

'--- some more VBA Code



End Sub

 

[stapuff]

as an fyi

The code I posted will place the .exe on top of the spreadsheet.

stapuff

 

[Jaafar Tribak]

as an fyi

The code I posted will place the .exe on top of the spreadsheet.

stapuff

Where exactly does the .exe appear et the moment ? does it appear as a flashing icon on the taskbar ?

and when you say 'on top of' do you mean by that you want it on top of the form or inside it ?

 

[stapuff]

Jaafar -

The piece of code I posted...when the button is clicked the .exe open on top of the spreadsheet.

What I want is the .exe to open inside of a control of a userform (become part of the userform) not just sit on top of it.

Thanks,

stapuff