VBA open desktop application !!

[Ks1102]

Hi, all
does it possible to have vba code which can call and open the application which located at PC desktop ?
please help and advice?
thanks very much .

 

[Ks1102]

Hi, all
does it possible to have vba code which can call and open the application which located at PC desktop ?
please help and advice?
thanks very much .

I find the code which searched by MrExcel who's Hermanito provided below.
but i don't how MOD what i to used ...
example :desktop located is "C:\Documents and Settings\Kenneth\Desktop"
file to open is " apac.zmd"
please help how to modify. thxxx

Sub Test()
    Dim FileName As String
    FileName = Environ("USERPROFILE") & "\Desktop\" & "test.lnk"
    FileName = "Excel " & """" & FileName & """"
    Call Shell(FileName, vbHide)
End Sub

 

[GTO]

Hi there,

What is it exactly that is on the desktop? Is it a shortcut to a file, or the file itself? Also, what type of file is it, or if a shortcut, what type of file does the shortcut point to?

Mark

 

[Ks1102]

Hi there,

What is it exactly that is on the desktop? Is it a shortcut to a file, or the file itself? Also, what type of file is it, or if a shortcut, what type of file does the shortcut point to?

Mark

Hi GTO
Thanks you read,
the shortcut is application itself.

 

[GTO]

Hi GTO
Thanks you read,
the shortcut is application itself.

I am afraid I may be misunderstanding. Is it a shortcut to an application? That is, you click on it and it runs an application, such as Excel? If so, what application are we wanting the code to run?