+ Reply to Thread
Results 1 to 5 of 5

Want a input box to make a copy of master file and rename it automatically

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Post Want a input box to make a copy of master file and rename it automatically

    hello everyone
    hope u will be ok

    i want a macro. when i run this macro pop up a input box and ask for copy of master copy and asked for rename the file...

    e.g
    i have a master file in "z:\42766\dec\masterfile.xlsm

    when i click macro then macro do a copy of masterfile and rename it according to choice...

    plz help

    thanx

  2. #2
    Registered User
    Join Date
    08-27-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Want a input box to make a copy of master file and rename it automatically

    Ok, This may not be the best way of doing what you want but should just about do the trick. The code used is as below.

    Please Login or Register  to view this content.
    Find sheet attached for example.

    Hope this helps!
    Attached Files Attached Files

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: Want a input box to make a copy of master file and rename it automatically

    Thanx for reply

    but this is not what i want

    i want to copy a worbook1 and make it rename by me

    e.g
    i have a workbook in z:\42766\dec\

    i want a copy of workbook like : workbook2
    and rename it what i choose like : my new workbook

  4. #4
    Registered User
    Join Date
    08-27-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: Want a input box to make a copy of master file and rename it automatically

    This is merely saving the sheet as a seperate filename the end result being 2 workbooks exactly the same with different names (the second specified in TextBox1) if this isn't what you want to end up with I must be misunderstanding what you want to achieve.

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,078

    Re: Want a input box to make a copy of master file and rename it automatically

    OK
    suppose

    i m working on workbook1

    i want to create a workbook2

    but i use every time copy of my "workbookmaster" like templates file

    i copy every time of "workbookmaster" and rename it by manually ......wrokbook1, workbook2, workbook3

    my "workbookmaster" file is always in c:\42766\march\workbookmaster.xlsm

    i go to here c:\42766\march\workbookmaster.xlsm
    and i make a copy of workbookmaster and rename it manully

    i want it using vba
    like i m working on workbook1, and i want to create a another workbook "workbook2" from workbookmaster in path c:\42766\march\

+ 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. How can I make my 'master' worksheet read-only whist allowing macro input.
    By gilko86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-16-2012, 03:59 PM
  2. Copy & rename sheets across multiple workbooks into one master.
    By CapnSef in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 01-25-2012, 03:58 AM
  3. Rename Multiple Excel Sheets Using Master Vlookup Sheet File
    By avantgti7 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2010, 10:58 AM
  4. Create additional tabs automatically based on input from master sheet
    By davidshluger in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-30-2010, 12:02 PM
  5. Replies: 1
    Last Post: 03-09-2008, 12:02 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