+ Reply to Thread
Results 1 to 3 of 3

Creating clone worksheet with predetermined name without saving it

  1. #1
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague
    MS-Off Ver
    Excel 2013
    Posts
    159

    Creating clone worksheet with predetermined name without saving it

    Hi All,

    Does anyone know how to create clone of existing workbook with multiple sheets, without saving it? I need to make exact copy of the original workbook (all sheets, formulas and macros), after which will be followed with VBA which will rearrange with the data and sheets in the new, cloned workbook.

    I also need to be able to rename the new workbook based on predetermine criteria (without saving it).
    e.g.: "Clone workbook 2017.10.20 10:10:06" , where "Clone workbook" will be same text for each new workbook, and "2017.10.20 10:10:06" is the date and time where the clone workbook was crated.

    Thank you in advance for your help.

    Igor

  2. #2
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Creating clone worksheet with predetermined name without saving it

    Saving the worksheet is what gives it a (new) name
    I can't see a way around what you are trying to do without saving it


    Does anyone know how to create clone of existing workbook with multiple sheets, without saving it? I need to make exact copy of the original workbook (all sheets, formulas and macros),

    = save workbook under new name (= Clone workbook 2017.10.20 10:10:06)


    after which will be followed with VBA which will rearrange with the data and sheets in the new, cloned workbook.
    = run VBA and save workbook



    Why do you not want to save the workbook?
    Last edited by kev_; 10-20-2017 at 04:30 AM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear

  3. #3
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague
    MS-Off Ver
    Excel 2013
    Posts
    159

    Re: Creating clone worksheet with predetermined name without saving it

    hi kev_

    Thank you for your input. I was just wondering if it is possible to do it.

    At the end I've took different (simpler) approach. In same workbook I've created sheet with the final template (which is hidden). When i run the macro, it transfer the data to the final template, and hides all other sheets. With this, there is no need for some extra crazy complicated macros.

    cheers
    igor

+ 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] Need help for creating new sheet with predetermined tabular column in it
    By gm2612 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-15-2014, 09:17 AM
  2. [SOLVED] Code Creating new folder with predetermined filename
    By ufopilot3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-18-2012, 01:00 PM
  3. Clone worksheet from one workbook to another?
    By csulli in forum Excel General
    Replies: 5
    Last Post: 08-18-2010, 03:17 PM
  4. Clone an existing worksheet
    By Kop99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2009, 08:38 AM
  5. Creating+saving multiple charts from a single worksheet
    By Cristo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-18-2009, 04:10 PM
  6. [SOLVED] saving file name based on value in predetermined cell
    By jatman in forum Excel General
    Replies: 5
    Last Post: 05-24-2006, 08:36 AM
  7. Best Technique to clone worksheet
    By Rich_z in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2005, 03:05 PM

Tags for this Thread

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