+ Reply to Thread
Results 1 to 4 of 4

Create copy of workbook with Macro

  1. #1
    Registered User
    Join Date
    06-03-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    27

    Create copy of workbook with Macro

    I need Macro code to save file copy without formula and Macro code in saved copy with specified name.
    This code should Exclude Specific Sheet Name in creating copy of workbook. For Example workbook have 5 sheet than sheet 1(xyz) should not be copied to new workbook
    Also want to disable manual Save and SaveAs as option.
    file contain protected cells so during running macro i need to unlocksheet and and protect again orginial.

    I have attached file on which i need to do same. I will insert button to export copy file.

    here is attached file on which i need to run above code.
    I don't have much knowledge of Macro.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-03-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    27

    Re: Create copy of workbook with Macro

    Any one can help solve above case.

  3. #3
    Valued Forum Contributor meabrams's Avatar
    Join Date
    10-03-2014
    Location
    USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    451

    Re: Create copy of workbook with Macro

    Need more information on what you are trying to do…. Do you want the sheet not to copy over if it already exists in book you are copying it to or do you want it to rename to a different name? Is there certain sheet that you never want to copy over? Is the Sheets stored in currently opened file or in a different file? Is the file it is copying the data to always going to be the same name stored in the same spot?

    The disabling of the Save is the easy part! You Can remove he MsgBox line if you don't wish forth message to show up every time someone try's to save.

    In This workbook place the following code
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-03-2016
    Location
    India
    MS-Off Ver
    2013
    Posts
    27

    Re: Create copy of workbook with Macro

    Thank for code for disabling saveas option.

    I have provided sample workbook above.
    File 1 & file 2.

    For File 1:
    Export all Sheets(Except Master sheet) to New single workbook with same sheets name in new workbook. and show popup where to save newly created workbook.

    i have attached before and after example.


    For File 2:
    export all sheet(Except Instruction Sheet) to new one workbook with same sheets name as value only without any formula & macro in it. and show popup to where to save exported workbook.
    Attached Files Attached Files

+ 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] Create new workbook & copy data over from existing workbook
    By xlyfe in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-14-2016, 06:12 AM
  2. [SOLVED] A macro to create a new workbook and copy data
    By mamuka12 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-05-2016, 10:19 PM
  3. [SOLVED] VBA code to create a workbook and copy or move worksheets in to workbook through loop
    By anishkumarvs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-16-2015, 05:40 AM
  4. [SOLVED] Macro to copy sheets from workbook and create new workbook
    By sudric in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2015, 11:53 AM
  5. Create Copy of workbook using macro and Name them as per list
    By VJOSHI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2014, 07:27 AM
  6. [SOLVED] copy active sheet, create new workbook, name new workbook based on cell reference
    By jm0392 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-20-2012, 07:12 PM
  7. Macro to Create a set of folders and copy the active workbook
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2009, 07:12 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