How to speed up this code ( cosolidates data from multiple excel files)

[prabhuduraraj09]

Hi all,

I have consolidation workbook, which got below code.
This consolidates data from multiple excel file to consolidation work book.

The challenges are as follows,
1) Code is collating data very slowly, for 40 files it takes around 5 minutes
2) If the Number of files is more in the folder path, then the consolidation workbook force closes.

I think code is not efficient enough.

Could someone look into the code and feel free to edit it please.

Please Login or Register  to view this content.

[TMS]

For a start, get rid of all the selects and activates.

For example, this:

Please Login or Register  to view this content.

can be this:

Please Login or Register  to view this content.

[prabhuduraraj09]

Hi,

Without change above given piece of code runs in 01 min 16 seconds
But with change you have proposed it runs in 01 min 38 seconds

can you suggest, whatelse change i can do.

[TMS]

Please post sample workbooks ... one with the code and one or more data files.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Keebellah]

I looked at your code and simplified it some, maybe this helps, it all depends on the ammount of data you are copying and pasting

Please Login or Register  to view this content.

Without sample files (dummy data) it's hard to tell