Run an EXE

[JohnPapa]

In the Target of a shortcut I run the following .exe successfully

"C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"

When I try to execute the same with Shell,

    Dim myPath2 As String
    myPath2 = "C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"
    Call Shell(myPath2, 1)

I receive Run time error 5
Invalid Procedure Call or Argument

 

[xavier.batlle]

In VBA, executing a shell command with spaces in the path requires enclosing the path in double quotes. Here’s how you can do it in MS Access VBA:

myPath2 = """C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"""

 

[JohnPapa]

I had tried this before

    Dim myPath2 As String
    myPath2 = """C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe"""
    Call Shell(myPath2, 1)

Same problem

 

[Gasman]

I had tried this before

Yet never thought to mention it?

 

[Isaac]

I just tested your same code with notepad.exe path, and it worked fine. check your path for correctness

 

[JohnPapa]

The following works

CreateObject("Shell.Application").Open ("C:\Program Files (x86)\VATECH\EzDent-i\Bin\VTE2Loader_ReqAdmin32.exe")