Desktop path

[Edson]

How can I refer to user's desktop path using VB?
Tks in advance

 

[Dave Peterson]

VBA?

If yes, then one way:

Option Explicit
Sub testme()
Dim myDesktopPath As String
myDesktopPath = CreateObject("WScript.Shell").SpecialFolders("Desktop")
MsgBox myDesktopPath
End Sub

 

[Edson]

tkx, Dave.

VBA?

If yes, then one way:

Option Explicit
Sub testme()
Dim myDesktopPath As String
myDesktopPath = CreateObject("WScript.Shell").SpecialFolders("Desktop")
MsgBox myDesktopPath
End Sub

 

[Harlan Grove]

If yes, then one way: ....
Sub testme()
Dim myDesktopPath As String
myDesktopPath = CreateObject("WScript.Shell").SpecialFolders("Desktop")
MsgBox myDesktopPath
End Sub

....

If users haven't gotten too creative, it's usually

Environ("USERPROFILE") & "\Desktop"