+ Reply to Thread
Results 1 to 2 of 2

How to AutoSave backup when press exit button on userform

  1. 09-09-2014, 03:39 AM #1
    z-eighty2
    z-eighty2 is offline
    Registered User
    Join Date
    02-22-2013
    Location
    pakistan
    MS-Off Ver
    Excel 2007
    Posts
    89

    How to AutoSave backup when press exit button on userform

    Hi everyone!

    I have got a excel file with userforms in it . I am looking for the code that will make a auto save backup file when I press "Exit " button from userform after finishing work.

    The backup should be created in different computer drive.

    Please help

    Thanks very much

    Kind Regards
    z-eighty2
    Reply With QuoteRegister To Reply
  2. 09-09-2014, 04:51 AM #2
    nathansav
    nathansav is offline
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: How to AutoSave backup when press exit button on userform

    thisworkbook.saveas "BACKUP.xlsm"
    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
    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)

Similar Threads

  1. [SOLVED] exit sub when press cancel button on userform
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2014, 01:13 AM
  2. Show Required UserForm when Press button from Main From...
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2013, 08:37 PM
  3. Autosave Backup Doc with Date in Name
    By SamSizzle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-14-2009, 03:43 PM
  4. Userform (Windows Exit Button)
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2007, 03:49 PM
  5. [SOLVED] Looping procedure calls userform; how to exit loop (via userform button)?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-27-2005, 08:05 AM

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