+ Reply to Thread
Results 1 to 3 of 3

vba copy specific sheet from closed workbook to active workbook

  1. #1
    Forum Contributor
    Join Date
    02-11-2014
    Location
    mauritius
    MS-Off Ver
    MS365
    Posts
    1,086

    vba copy specific sheet from closed workbook to active workbook

    I looking a code that copies from closed workbook in which there are several worksheets

    path c:\\sample\proton.xlsx a specific worksheet named WORKINGS and insert it to last sheet in active opened workbook

    Thanks if any one can assist

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: vba copy specific sheet from closed workbook to active workbook

    Try this code
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: vba copy specific sheet from closed workbook to active workbook

    Thanks for marking the thread as solved...

+ 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 Select Columns from closed workbook into active workbook
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 10-09-2015, 02:04 PM
  2. Copy from active workbook to a closed workbook
    By GEMINI528 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-29-2014, 11:46 AM
  3. copy of sheet from specific workbook to active workbook
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2014, 07:31 AM
  4. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  5. Run Macro in closed workbook and copy specific coloumn in active workbook
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2013, 03:43 AM
  6. Macro to copy row to specific sheet in closed workbook
    By newbie-excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-04-2013, 12:51 PM
  7. Copy worksheet from closed workbook into active/existing workbook.
    By rasikvekaria in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-26-2012, 06:55 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