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

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 wrote:
>
> How can I refer to user's desktop path using VB?
> Tks in advance

--

Dave Peterson

tkx, Dave.

"Dave Peterson" <(E-Mail Removed)> escreveu na mensagem
news:(E-Mail Removed)...
> 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 wrote:
>>
>> How can I refer to user's desktop path using VB?
>> Tks in advance
>
> --
>
> Dave Peterson

Dave Peterson <peter...@verizonXSPAM.net> wrote...
....
>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"