+ Reply to Thread
Results 1 to 9 of 9

Find Anyones Desktop Folder

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Find Anyones Desktop Folder

    Hi,

    I am having an issue with trying to find anyone's desktop folder. I'm trying to write a path to the desktop but once again the desktop is different on every computer. The problem line is in red...



    Any Idea's Thank You, Mike

    Please Login or Register  to view this content.
    I have used this in the past to save files to anyone's desktop but now I have to find or look for these folders so I can access the files?


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by realniceguy5000; 06-04-2009 at 08:54 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Find Anyones Desktop Folder

    This works for me
    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Find Anyones Desktop Folder

    Quote Originally Posted by royUK View Post
    This works for me
    Please Login or Register  to view this content.
    Thank You, Roy...

    Ok That works better, It finds the desktop but not the folder I'm looking for?

    Please Login or Register  to view this content.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,996

    Re: Find Anyones Desktop Folder

    You have one too many backslashes:
    Please Login or Register  to view this content.
    could just be:
    Please Login or Register  to view this content.
    Everyone who confuses correlation and causation ends up dead.

  5. #5
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Find Anyones Desktop Folder

    Quote Originally Posted by romperstomper View Post
    You have one too many backslashes:
    Please Login or Register  to view this content.
    could just be:
    Please Login or Register  to view this content.


    Yes that's what I thought as well. I tried that but it still isn't looking in the correct folders?
    Thanks for the thought though...
    Mike

  6. #6
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,996

    Re: Find Anyones Desktop Folder

    Where is it looking?

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Find Anyones Desktop Folder

    mayb use ChDir

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Find Anyones Desktop Folder

    Roy's code adds the path separator at the end of the desktop path, so,
    Please Login or Register  to view this content.
    You need to work on your debugging skills, RNG.
    Entia non sunt multiplicanda sine necessitate

  9. #9
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Re: Find Anyones Desktop Folder

    Quote Originally Posted by shg View Post
    Roy's code adds the path separator at the end of the desktop path, so,
    Please Login or Register  to view this content.
    You need to work on your debugging skills, RNG.
    You are Right shg... Not too surprising... Anyway I found out what I was doing wrong. When the user clicks the button to run the script I only had it setup like this below See (A) .
    When the sub went to run the Sub continue part I had unexpected results.

    Once I put the entire script in the command button click proceedure it worked corectly.See(B)

    Another lesson learned... Dont spit code up.

    Thanks for the help again guys...

    Mike

    Not working Script: (A)

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Working Script: (B)

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

+ 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