Results 1 to 13 of 13

Copy Numerous Sheets to Numerous Unopened Workbooks

Threaded View

  1. 04-23-2018, 05:23 AM #7
    Marc L
    Marc L is offline
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Copy Numerous Sheets to Numerous Unopened Workbooks


    Yes as you can see in VBA inner help but as you save the workbooks avoid GetObject (sorry I didn't see that before)
    'cause your workbooks will be saved hidden !

    Better is to desactivate the display via ScreenUpdating property (to see in VBA inner help) …
    Last edited by Marc L; 04-23-2018 at 05:33 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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 cell A3 and Cell A5 of numerous sheets into a single sheet
    By aarona in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2017, 01:56 AM
  2. Difficulty Creating Data Connection between numerous Workbooks
    By PNommay in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-09-2012, 05:08 PM
  3. make numerous workbooks open in excel
    By Tom123 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-11-2011, 02:22 PM
  4. Data Extraction from numerous workbooks
    By bholabhala in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-02-2011, 03:05 PM
  5. Retrieve data from numerous workbooks inside a Master File
    By Staci in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 03-29-2011, 07:30 PM
  6. Pull out specific values from numerous workbooks
    By jimmy1981 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-21-2010, 04:19 AM
  7. [SOLVED] Efficient way to copy a range in numerous sheets within a workbook
    By Steve O in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2005, 09:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1