Hello again,
I've been checking my code and been doing some testing...
In my code I either called a batchfile directly the way you use in the first post. That works. I expect all executable files will work this way (.exe, .com, .bat)
When I open a certain .eASM file (eDrawings Assembly file), I included the application location to open the application and the filename as parameter to the application. That also works.
Directly trying to open the filename, relying on the 'double-click' functionality in Explorer seems not to work
So, in short, I think you need to know what the parent application is, and call that one, with the filename as a parameter. To account for spaces in pathnames, also add quotes where necessary.
Example:
Code:
Sub Test()
Dim FileName As String
FileName = Environ("USERPROFILE") & "\Desktop\" & "test.lnk"
FileName = "Excel " & """" & FileName & """"
Call Shell(FileName, vbHide)
End Sub
In this case, I put a link to an Excelfile on my desktop. Since Excel can be started as is (its location is in the system-PATH), I don't need to provide the exact location of the .exe file.
I'm thinking there must be a better way to do this, it is ridiculous that you have to know the location of the parent application to open a shortcut...
I'll try to find something else, but in the meantime, you could try the workaround I explained...
ciao,
H
