+ Reply to Thread
Results 1 to 2 of 2

VBA to copy sheet to another workbook

  1. #1
    Registered User
    Join Date
    05-14-2015
    Location
    IOWA CITY, IOWA, USA
    MS-Off Ver
    2010
    Posts
    30

    VBA to copy sheet to another workbook

    I am trying to make a code that will copy a specific worksheet to another workbook that is not open and rename the sheet once copies.

    Starting with workbook 'Master Tracking' when I run my macro I want it to copy sheet 'Notify Clinic' to workbook 'Consult Notifications' located at 'C:\Spreadsheets'. The target workbook would not be open when the macro is ran, and would ideally save and be closed after the sheet is pasted in. I also want it to rename the sheet in the target workbook to reflect that days date.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,645

    Re: VBA to copy sheet to another workbook

    You'll need to open the target workbook to copy a worksheet to it.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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] Copy sheet from another workbook based on ComboBox names of the Workbook and sheet
    By igormigor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2016, 10:07 AM
  2. [SOLVED] macro to copy rows from a sheet in one workbook to a sheet in a different workbook...
    By fredderf81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-16-2013, 01:36 PM
  3. Simple Open Workbook, Copy Sheet, Paste In New Workbook Question
    By alulla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 02:10 PM
  4. Replies: 0
    Last Post: 04-26-2013, 03:40 AM
  5. [SOLVED] Copy Values From Each Workbook in Folder to a Single Sheet in New Workbook +Workbook names
    By Arsham24 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2012, 07:42 PM
  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

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