+ Reply to Thread
Results 1 to 4 of 4

Opening Excel Workbooks via a Macro takes really long

  1. #1
    Registered User
    Join Date
    12-18-2020
    Location
    Nuremberg, Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Question Opening Excel Workbooks via a Macro takes really long

    Hello everyone. I am trying to create a macro which opens several workbooks and copies a single worksheet out of them into my main workbook.

    I already have working code for that task, however my macro is really slow when opening other excel files from my computer.

    Here is my code:

    Please Login or Register  to view this content.
    Like I said: Workbooks.Open(...) takes really long (several minutes) and I don't know how to combat this.

    Thanks everyone in advance!

  2. #2
    Registered User
    Join Date
    12-18-2020
    Location
    Nuremberg, Germany
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Opening Excel Workbooks via a Macro takes really long

    Let me correct: Opening everything works in a few seconds, however copying takes ages. Sorry for the wrong information.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,124

    Re: Opening Excel Workbooks via a Macro takes really long

    OK, so please update the title of the opening post accordingly. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    11,138

    Re: Opening Excel Workbooks via a Macro takes really long

    Opening everything works in a few seconds, however copying takes ages
    So...what is it you are copying...Why not upload a sample file of 1 or 2 of theses workbooks and explain in detail what you are trying to achieve...perhaps an alternate solution can be offered...See Top yellow Banner
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ 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. Opening Excel Workbook [takes too long with Workbook_Open]
    By brentjohn in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-30-2018, 04:34 PM
  2. [SOLVED] Opening CSV file through VBA takes unrealistically long
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2016, 09:54 AM
  3. macro too long and takes too long needs simplifying
    By margal in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2016, 05:26 PM
  4. Inefficient code - macro takes too long
    By dantray02 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-07-2014, 09:29 AM
  5. Replies: 0
    Last Post: 05-17-2013, 09:21 AM
  6. how do i add time to see how long my macro takes to run
    By ernestgoh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2006, 06:10 AM
  7. Counting how long a Macro takes to run
    By Diane Alsing in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2005, 02:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1