+ Reply to Thread
Results 1 to 4 of 4

Save a copy of current file

  1. #1
    Registered User
    Join Date
    08-11-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    43

    Save a copy of current file

    Hello,
    I need a code to save a copy of a file.
    let's say I have a template and I filled a few data, I need to save it in separate, so I can keep that template for the next time I need to use it.
    Thanks in advance.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,528

    Re: Save a copy of current file

    Change references where required.
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-11-2019
    Location
    USA
    MS-Off Ver
    365
    Posts
    43

    Re: Save a copy of current file

    Thank you, it works perfectly.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,915

    Re: Save a copy of current file

    If you saved it as a template, it should open as a new workbook by default anyway assuming you either double clicked it in explorer, or used File - New, then selected the template.
    Rory

+ 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. Ensure that File Name Save As Different Name than Current File Name
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2019, 11:03 AM
  2. [SOLVED] How to Save as a file with current date and specific text as file name
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2018, 12:30 AM
  3. In Current workbook- copy sheets from other workbooks and save in current workbook
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2016, 08:41 PM
  4. Save a copy of current .xlsm file without closing the original
    By gezza07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-24-2013, 08:52 PM
  5. Replies: 1
    Last Post: 09-05-2013, 02:39 PM
  6. macro save file for current year and month with a file name SHReportddmmyy.xls
    By evwang in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-14-2011, 10:38 PM
  7. Copy a sheet into a new book and save file name as the current date.
    By Jay3 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 07-10-2009, 06:59 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1