+ Reply to Thread
Results 1 to 2 of 2

workbook to extract data without reactivate

  1. #1
    Forum Contributor
    Join Date
    12-11-2009
    Location
    Toronto
    MS-Off Ver
    Excel 2010
    Posts
    517

    workbook to extract data without reactivate

    Hi, using the code below, how can i extract data from this workbook to another workbook without having to reactivate it over and over again in a loop? thanks
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-28-2014
    Location
    harbin,china
    MS-Off Ver
    2007
    Posts
    162

    Re: workbook to extract data without reactivate

    Hi, biznez

    try this

    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. extract cell data from one workbook to master workbook
    By mikey141 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-19-2015, 11:05 PM
  2. Extract all data to new workbook then filter and extract to new worksheets
    By graphicgoose in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-04-2014, 08:18 PM
  3. [SOLVED] Extract data from one workbook and populate a separate workbook
    By gobeavers in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2012, 05:45 PM
  4. Extract data from 1 workbook to create report in 2nd workbook
    By singingstomacg in forum Excel General
    Replies: 0
    Last Post: 07-10-2012, 05:04 PM
  5. Reactivate Sheet
    By Streng in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2009, 08:46 AM
  6. Extract selected Data from workbook to workbook
    By leopradeep in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-04-2007, 06:21 PM
  7. [SOLVED] Deactivate then Reactivate UpdateLinks
    By TOMB in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2006, 06:23 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