Results 1 to 2 of 2

need vba to copy sheets from closed workbook and paste into all closed wb's

Threaded View

breadwinner need vba to copy sheets from... 04-19-2016, 02:24 PM
jaslake Re: need vba to copy sheets... 04-20-2016, 01:25 PM
  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    need vba to copy sheets from closed workbook and paste into all closed wb's

    Dear experts

    I have N number of xlsb workbooks in target path i want add four sheets in every closed workbook from particular file. i getting tired by doing manually for this task

    i have files like Jan,Feb,Mar,....etc in path folder C:\Users\Zionscar\Desktop\fy-16. and
    i have saved separate workbook called zonefile.xlsb in separate path with four sheet zone1,2,3,4 i want add these four sheets into every files in target path.

    please find the attachment
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Copy and Paste in closed workbook
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2014, 08:31 AM
  2. Copy and Paste from a Closed Workbook
    By Sean Ross in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-12-2013, 10:26 AM
  3. Copy 2 sheets from a open workbook and paste to a closed workbook
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 03:27 PM
  4. Copy One Sheet From One Closed Workbook To Another Closed WB
    By teshiburu1988 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2009, 11:49 AM
  5. Copy sheets from closed workbook
    By heinz1218 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-03-2009, 11:48 AM
  6. copy sheets from closed workbook
    By blackvba in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2008, 06:08 PM
  7. [SOLVED] Possible to copy sheets into another (closed!) workbook?
    By Grotifant in forum Excel General
    Replies: 5
    Last Post: 02-23-2005, 05:06 AM

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