+ Reply to Thread
Results 1 to 3 of 3

How to path to user's desktop

  1. #1
    Registered User
    Join Date
    02-16-2006
    Posts
    22

    How to path to user's desktop

    Is there a function that will return the User's Name or the path to their desktop folder?

  2. #2
    Tom Ogilvy
    Guest

    RE: How to path to user's desktop

    The desktop is one of the special folders:

    http://support.microsoft.com/default...b;en-us;252652
    HOWTO: Use the SHGetFolderPath Function from Visual Basic

    http://msdn.microsoft.com/library/de...nums/csidl.asp

    or you can use the windows scripting host:

    Create a link to the Windows Scripting Host Runtime libary
    C:\WINDOWS\SYSTEM\WSHOM.OCX


    Name is: IWshRuntimeLibrary


    In Tools=>References in the VBE it will be listed as: Windows Scripting Host
    Object Model or something similar.


    You can use this to get your desktop location:


    Sub Tester15()

    Dim wsh As New IWshShell_Class
    Dim DesktopPath As String
    DesktopPath = wsh.SpecialFolders.Item("Desktop")
    msgbox DeskTopPath
    end Sub


    or without setting the reference

    Sub Tester16()
    Dim wsh As Object
    Dim DesktopPath As String
    set wsh = CreateObject("wscript.shell")
    DesktopPath = wsh.SpecialFolders.Item("Desktop")
    msgbox DeskTopPath
    end Sub

    --
    Regards,
    Tom Ogilvy

    "1scant" wrote:

    >
    > Is there a function that will return the User's Name or the path to
    > their desktop folder?
    >
    >
    > --
    > 1scant
    > ------------------------------------------------------------------------
    > 1scant's Profile: http://www.excelforum.com/member.php...o&userid=31635
    > View this thread: http://www.excelforum.com/showthread...hreadid=552615
    >
    >


  3. #3
    Registered User
    Join Date
    02-16-2006
    Posts
    22
    Beautiful! And I got your reply just at the right time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1