+ Reply to Thread
Results 1 to 12 of 12

Saving MASTER file, automatically remove part of file name and append current date?

  1. #1
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Saving MASTER file, automatically remove part of file name and append current date?

    Hello,

    I have CRM_Master.xls.

    When I save the document, I want it to save as CRM_090914.

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    good for you
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Thanks for the snark! Good Morning.

    Do you know how to do this via VBA?

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Google it.

  5. #5
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Nathan,

    If that worked for me, I wouldn't be posting here.

  6. #6
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    untested

    Please Login or Register  to view this content.

  7. #7
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Hello EnigmaMatter,

    No everyone on the board is a Sasannach (Alba gu brath!).

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  8. #8
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    I was able to use the Macro Recorder and a reference in a different problem to answer my question.

    http://stackoverflow.com/questions/2...g-vba-in-excel

  9. #9
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    You sure there was nothing when you googled save as VBA or when you looked on the VBA help files?

  10. #10
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    There was, but I didn't quite get how it worked, or it was hidden in a larger solution. Usually I find more complex code than needed. This forum usually gives me 1-liners or better versions of my existing code.
    Thank You,

    EnigmaMatter

  11. #11
    Forum Contributor
    Join Date
    02-04-2014
    Location
    Florida, United States
    MS-Off Ver
    Excel 2010, Excel 2013
    Posts
    366

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Leith, thank you! I used code that looked very similar to yours.

  12. #12
    Registered User
    Join Date
    04-07-2014
    Location
    Port Talbot, Wales
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Saving MASTER file, automatically remove part of file name and append current date?

    Alba gu brath - Scotland forever my friend

+ 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. Replies: 1
    Last Post: 10-25-2013, 12:49 AM
  2. Append saved file name with current date and in .xlsm format
    By SAThomas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2012, 01:51 PM
  3. Saving file to its current location and current file name with current date and "FINAL"
    By ironwill20 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-21-2012, 03:22 AM
  4. adding current date then after saving the file current date function stops
    By gotbitey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2011, 02:15 PM
  5. Replies: 0
    Last Post: 11-16-2011, 01:35 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