VBA Command Shell Syntax

Question

VBA Command Shell Syntax

Juergen Hoffmann 1

Hello, I just want to open a file.
In this example the CALC, exe runs without problems,
The file, a soundtrack, cannot be found in the code at the end, why? The code has only been modified, but basically remained the same. Calc can be started but the soundtrack cannot?

Private Sub TestFeld_DblClick(Cancel As Integer)
'Testfeld
'Dim Ergebnis
'Ergebnis = Shell("C:\WINDOWS\system32\CALC.EXE", 1)
'Close
'_______________________________________________________________________
Dim Start
Start = Shell("C:\Vokabel\34blabla.vma", 1)
End Sub

I need that call, becouse i working on my own Learn DB.
Can some please help me.

1 answer

Your answer

Answer 1

Castorix31 90,681

You can see : How To Use ShellExecute to Launch Associated File (32-bit)

Tom van Stiphout 1,861 Reputation points MVP Volunteer Moderator

2021-09-23T01:18:33.6+00:00

Castorix is correct. To explain the difference: Shell is smart enough to run simple executables. Those files have a ".exe" extension. It is NOT smart enough to do what File Explorer does when you double-click a vma file, a txt file, or whatever, which is to invoke the registered application for that file extension and pass in the filename. ShellExecute is that smart.

Share via

VBA Command Shell Syntax

1 answer

Your answer