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]
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]