+ Reply to Thread
Results 1 to 3 of 3

Save File With Date

  1. #1
    Registered User
    Join Date
    11-28-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    73

    Save File With Date

    I have searched this one for a while now and came close but never get the result that I'm after. I'm sure it's something really easy but I have way too much time invested in it. When the macro ends I need the result to be saved as "Test 07.12.19" but I always wind up with Test (07.12.19) and every time I try and remove the "( )" it fails. Any help is always appreciated!

    Please Login or Register  to view this content.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,422

    Re: Save File With Date

    I presume you have tried this?

    Please Login or Register  to view this content.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    11-28-2011
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    73

    Re: Save File With Date

    AliGW - It worked... Thank you! I was at the point of complete aggravation because each instance of pasting in the data and then re-running was a time consuming process. I do appreciate the humor too because if I had tried your version first I wouldn't have been here asking (that's me being a grateful wise a$$). Thank you again!!!

+ 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. [SOLVED] How to Save as a file with current date and specific text as file name
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2018, 12:30 AM
  2. Save, Date, Rename File and Auto Save
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2017, 05:16 AM
  3. [SOLVED] Macro to save file - save name from cell containing a date using different date formatting
    By d_max_c in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 12:18 PM
  4. [SOLVED] save open worksheet to file and include date of save
    By shaz0503 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-12-2014, 08:50 AM
  5. Replies: 1
    Last Post: 10-25-2013, 12:49 AM
  6. [SOLVED] Save invoice to folder by month and then save file by date and invoice
    By Val777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2013, 02:57 AM
  7. Macro to save Excel file with date and time in the file name?
    By sonic_d_hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 02:00 PM

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