+ Reply to Thread
Results 1 to 2 of 2

Merging files by macro

  1. #1
    Registered User
    Join Date
    03-24-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    office 365
    Posts
    5

    Merging files by macro

    Hi everyone,

    I've come to an issue, when I have to combine data from several hundreds to thousands Excel worksheets to one for easier processing. The macro works on one PC, but the thing is, that when I try to use it on a PC with much much better HW in every way, it is like at least four times slower or experiencing errors that set the macro processing into debug mode.

    For the description what the macro should do:
    It is given a path to a directory. In this path there are many other directories which are to be gradually opened and inside the directories there are 5 to 10 excel workbooks from which the several columns of data are to be copied to a new worksheet named by the folder name. Also there is a part that finds maximal value and sum of the values and gives it to a place which is easy to find and copy from.

    I have also tried to speed up the macro to be as fast as possible, but I am not sure if everything written down is actually helping to speed it up or even necessary.

    If you could help me to make it work correctly or even to further optimise it, I would be very grateful.

    Please Login or Register  to view this content.

  2. #2
    Registered User
    Join Date
    03-24-2017
    Location
    Prague, Czech Republic
    MS-Off Ver
    office 365
    Posts
    5

    Re: Merging files by macro

    I have forgotten to mention one issue. The macro works on Excel 2013 and does't work that well (or better to say hardly works) on Excel 2016 from Office 365.

+ 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. Simple Macro for Merging Excel Files Into One Consolidated File
    By Revitigs in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-23-2016, 11:06 PM
  2. Merging of multiple macro files
    By vmdhar2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2015, 06:45 AM
  3. merging files with macro
    By np1966 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2012, 01:33 PM
  4. Merging two files together based on col common to both files
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2011, 01:06 PM
  5. Merging/Condensing MS Project Files - Macro
    By Sean<3Coffee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2010, 10:34 AM
  6. Merging two files
    By oceanmd in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2008, 11:50 PM
  7. [SOLVED] Merging two different files
    By justinfisher in forum Excel General
    Replies: 0
    Last Post: 01-21-2005, 05:06 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