Results 1 to 26 of 26

Automatic save as backup when opening file

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Automatic save as backup when opening file

    I have been searching this site for assistance from other posts and have come up with variations, but I am not coversant enough to convert to what I need.

    Can someone give me a VBA script or is it Bolean? One that auto saves a file as it opens one.
    I'd like to have the file save the original name, but add date and time if possible.

    As I have multiple users I cannot use read only, as I need up to date data.

    For this purpose file name is "Class Roll 2015" Location C:\Rolls\
    and
    the folder for save as is in the same folder, name of ABC Backups Location C:\Rolls\ABC Backups\

    Is there a VBA script out there that can do this?

    thanks
    Last edited by Christopherdj; 01-29-2015 at 08:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Auto save a backup copy in a seperate location OR save file with a pop up
    By kdsanderson30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2014, 12:38 PM
  2. [SOLVED] Automatic Backup of Excel File on a daily basis
    By Mr.India in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-21-2014, 02:06 AM
  3. save:Automatic Backup
    By Zan03 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2013, 12:41 PM
  4. EXCEL file automatic regular (schedulled) backup in your email
    By Sobirjon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2013, 01:41 PM
  5. [SOLVED] Backup:always create a backup file in the save options
    By Alek in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 09:25 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