+ Reply to Thread
Results 1 to 4 of 4

Need dynamic file path to save on desktop regardless of user

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    97

    Need dynamic file path to save on desktop regardless of user

    Hello everyone! I am hoping someone can help me figure this out. The codes below saves my worksheet as a text delimited file on my desktop. Specifically it is used to remove the quotations around values that have commas in them. The problem I am having is that the code only works on my machine because the file path is directly referencing MY desktop. I need to alter this to work on anyone's machine. Any help will be much appreciated! Thank you!

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,411

    Re: Need dynamic file path to save on desktop regardless of user

    Hello,

    This link might help:
    http://stackoverflow.com/questions/1...rdless-of-user

    Based on that, you could use :
    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    08-17-2012
    Location
    New York, New York
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: Need dynamic file path to save on desktop regardless of user

    Thank you GC Excel!! I got it to work using your suggestion. Perfect!

  4. #4
    Registered User
    Join Date
    06-07-2015
    Posts
    1

    Re: Need dynamic file path to save on desktop regardless of user

    Hello, any idea how to have in names destination the current date and hour as well?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Save file with specific name and ask user for the path
    By kammariarun in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-08-2013, 05:19 PM
  2. Macro to save sheet as CSV using a dynamic file name and file path
    By chris.tinta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2013, 10:45 AM
  3. [SOLVED] Save As Dialog Box - Default Path and File Name, User Selects Sub Folder from Default Path
    By christenprochaska in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2012, 05:17 PM
  4. [SOLVED] How would I save a text file to a folder on the users desktop without knowing the path?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-21-2012, 01:36 PM
  5. How to path to user's desktop
    By 1scant in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-16-2006, 10:52 AM

Tags for this Thread

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