+ Reply to Thread
Results 1 to 3 of 3

Saving Backup Copies before Updateing File

  1. #1
    Registered User
    Join Date
    12-30-2012
    Location
    Nacogdoches, Tx
    MS-Off Ver
    Excel 2015
    Posts
    65

    Saving Backup Copies before Updateing File

    I need to save a backup copy of my file before I update and reset the pages for the next day.

    I want a backup for each day of the year.

    I can use these:
    Please Login or Register  to view this content.
    But have to change the file name on line three every day.

    The file name in the code on the third line of this coed ie (4 Daily Balance Jan 9th 2013) need to change each day by one day ie "Jan 10th, Jan 11th ect).

    Is there any way to make the code add the current day to the file name?

    The second part of the code saves the file back to it's original name and location before updating the file.

    Is the any way to code the command to replace the current file with the same name without asking me first?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Saving Backup Copies before Updateing File

    Hi,

    Please Login or Register  to view this content.
    See if this does the trick!
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Saving Backup Copies before Updateing File

    Hi,

    Please Login or Register  to view this content.
    See if this does the trick!

+ 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