+ Reply to Thread
Results 1 to 8 of 8

Save to any computer desktop

  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    perth,australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Save to any computer desktop

    Hi again all.

    I am using the code below to save a worksheet to my desktop, which is working fine. Is there a way to change the path, so that it will copy/save to any computers' desktop? Thank you so much for any help.



    Please Login or Register  to view this content.
    Last edited by fremarco; 07-20-2012 at 10:59 AM. Reason: Code tags not quote tags.

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,156

    Re: Save to any computer desktop

    Like this
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-13-2012
    Location
    perth,australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Save to any computer desktop

    Thanks Kyle. What if I only want to save/copy the worksheet only?
    Last edited by Cutter; 07-20-2012 at 11:33 AM. Reason: Removed whole post quote

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,156

    Re: Save to any computer desktop

    Just use the above to set your strfpath variable instead of your fixed string and th usevyourcode as it is

  5. #5
    Registered User
    Join Date
    03-13-2012
    Location
    perth,australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Save to any computer desktop

    Thanks again Kyle. The code works fine but can it be saved to a specific folder on the desktop (i.e pending) Sorry for taking so long to answer but wife wanted to go out...as they do. Cheers.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,156

    Re: Save to any computer desktop

    Yes, of course, but you should check that the folder exists first:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    03-13-2012
    Location
    perth,australia
    MS-Off Ver
    Excel 2007
    Posts
    25

    Re: Save to any computer desktop

    great! thanks a bundle Kyle

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,156

    Re: Save to any computer desktop

    no probs

+ 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