Opening an exe file using vba

cormanov

New Member
Joined
May 23, 2019
Messages
1
I have an excel file that has a list of exe files and I want to create a macro button to run those exe files. But for some reason it is not working for me. This is the code I used:

If Dir(ProgName(k)) <> "" Then 'check if executable file exists
RetVal = Shell(ProgName(k), vbNormalFocus)
Else
MsgBox "Program " & ProgName(k) & " could not be found"
End If

The ProgName(k) is a function that just takes whatever file they are on when they click the macro button. It keeps giving me an error on the Shell(ProgName(k), vbNormal) and I do not understand why? Shell works for exe files like my calculator but not for other exe files. I am trying to run this exe file and it will not work:
[TABLE="width: 558"]
<tbody>[TR]
[TD="class: xl67, width: 558"]N:\Mechanical Programs\Turbine Perf\turb.exe

This is in my network in my N drive. I tried copying it over to my C drive to see if that was the error but it still did not work[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top