+ Reply to Thread
Results 1 to 4 of 4

Copy workbook and rename

  1. #1
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Copy workbook and rename

    I want to open an existing workbook, make a copy, rename the copy only and have it remain open and retain the original workbook unchanged and not open.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Copy workbook and rename

    Change the path, file name and extension in the below code

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    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,198

    Re: Copy workbook and rename

    Hi, JJGF,

    the SaveAs command should work as expected:
    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

  4. #4
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Re: Copy workbook and rename

    Quote Originally Posted by HaHoBe View Post
    Hi, JJGF,

    the SaveAs command should work as expected:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Thanks, I used your code and modified a bit:

    Please Login or Register  to view this content.

+ 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. create new workbook, copy data, rename sheet.
    By simeonmein in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 02:00 AM
  2. copy sheets to new workbook with new name, rename tabs within that workbook
    By Conky4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-12-2012, 04:44 PM
  3. Copy Workbook, Save and Rename
    By questionguy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2012, 08:04 AM
  4. Copy and rename a sheet in an existing workbook?
    By robertse in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-09-2010, 02:00 PM
  5. Copy and rename worksheets to other workbook but not formulas
    By Oakstream in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2010, 09:27 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