+ Reply to Thread
Results 1 to 5 of 5

Save one sheet, and save work book as back up

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Exclamation Save one sheet, and save work book as back up

    Hi, I have macro code below.

    Currently it saves the work book as separate file (as back up).

    The file has three sheets. (Tip Calculator, Daily Payroll, Two Weeks Payroll).

    I want to be able to save (overwrite to current file) the "Two Weeks Payroll" Sheet only when I click the Macro Button.

    Can you help me? Thanks!


    -------------------------------------------------------------
    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 05-03-2014 at 04:05 AM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Save one sheet, and save work book as back up

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Save one sheet, and save work book as back up

    thanks. But this only saves as. Is it possible to save it and create bkup at the same time?

  4. #4
    Registered User
    Join Date
    04-30-2014
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Exclamation Save and Back Up at the same time

    How can I make a macro button that

    Saves the workbook, and create the back up file?

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Save and Back Up at the same time

    Hi, ryanlee84,

    you would only need to use an event for this, code goes into ThisWorkbook

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

+ 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. [SOLVED] Help Neded! Automatic save and shut down off work book!
    By dgavranovic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2014, 01:53 PM
  2. Replies: 6
    Last Post: 02-04-2013, 02:18 AM
  3. How to extract a particular data from Multiple work book and save it to single sheet/
    By Swapnanjali in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-28-2013, 05:17 AM
  4. unable to change the data and save the Work Book
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 01:39 PM
  5. Replies: 2
    Last Post: 04-20-2005, 09:06 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