+ Reply to Thread
Results 1 to 12 of 12

Automatically creating a back copy in other location which is updated at all times

  1. 03-09-2013, 10:06 AM #1
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Unhappy Automatically creating a back copy in other location which is updated at all times

    Hi ,
    I am using this code to make an automatic copy of work book in other destinations.
    I am learning on how to write the code.
    My file name is ABCDE and it is at C:/TP/NN ( NN is the folder)
    Path where back up copy is to be saved is C:/TP/BK( BK is the name of the folder)
    I want the data on back copy saved every time the main copy is modified, however if some one tries to delete any information, then the back up copy remains as it is.
    How it can be possible???
    I have a general code, but dont know how to rewrite it.
    Please help...


    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 03-09-2013 at 10:42 AM. Reason: Added code tags, as per forum rules. Don't forget!
    Reply With QuoteRegister To Reply
  2. 03-10-2013, 11:08 PM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automatically creating a back copy in other location which is updated at all times

    In the ThisWorkbook module, create a macro that makes a backup copy of the file everytime the file is opened. I can't imagine any better backup method since you will have difficulty knowing any other time whether the macro was edited.

    Please Login or Register  to view this content.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 03-13-2013, 06:05 AM #3
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Hi Sir,
    Thanks for the code above.
    This one does not work as intended. Do you propose another solution please.

    Kind regards
    Reply With QuoteRegister To Reply
  4. 03-13-2013, 08:25 AM #4
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automatically creating a back copy in other location which is updated at all times

    No, the SaveCopyAs method is the one to use when needing a backup copy of a file before any changes have occurred.
    Reply With QuoteRegister To Reply
  5. 03-13-2013, 09:32 AM #5
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Hi Sir,
    This book is used by many and they will keep using it , updating it from time to time.
    I was aiming at creating a copy of the same at other location, before it is modified automatically.
    The above solution seems good, however I did copy the code and pasted it in the first sheet, exactly the way you have helped me, however it does not create a copy.
    The intending folder 
    Please Login or Register  to view this content.
    remains empty. I am not sure where am I going wrong.
    Please help

    Kind regards
    Reply With QuoteRegister To Reply
  6. 03-13-2013, 09:49 AM #6
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automatically creating a back copy in other location which is updated at all times

    Follow the instructions in post #2 as to where the macro must reside.
    Reply With QuoteRegister To Reply
  7. 03-13-2013, 10:05 AM #7
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Hi Sir,
    Thanks.
    I am determined to learn. Thanks for leading me, however still struggling.... Need more help please.
    Bit confused ? . I have typed the code as follows

    Please Login or Register  to view this content.
    It does not work. I am still making a mistake. Sorry Sir. Help please
    Kind regards
    Reply With QuoteRegister To Reply
  8. 03-13-2013, 10:55 AM #8
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automatically creating a back copy in other location which is updated at all times

    Which code module did you put it in? I tested the macro as given moments ago and it's working fine. I'm guessing you still don't have it in the correct module. Read post #2 again.
    Reply With QuoteRegister To Reply
  9. 03-18-2013, 03:19 PM #9
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Hi Sir,
    It worked perfectly. I did make out where I was doing a mistake.
    Could not reply earlier as I was medically down for a while.
    Thanks
    Kind regards
    Reply With QuoteRegister To Reply
  10. 03-18-2013, 03:29 PM #10
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automatically creating a back copy in other location which is updated at all times

    Glad to help. Hope you're feeling better.
    Reply With QuoteRegister To Reply
  11. 03-19-2013, 05:22 AM #11
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Thanks JB Sir,
    Feeling much better and back to work now.
    Thanks again
    Regards
    Reply With QuoteRegister To Reply
  12. 03-24-2013, 09:26 AM #12
    KK1234
    KK1234 is offline
    Forum Contributor
    Join Date
    02-19-2013
    Location
    UK
    MS-Off Ver
    Excel 2019
    Posts
    677

    Re: Automatically creating a back copy in other location which is updated at all times

    Hi JB Sir,
    Need further help from you.
    Kind regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1