VBA code as presented keeps crashing

Howdy

I'm not a VBA expert, and what I compiled is mainly from reading through the internet. And code keeps crashing the excel midway through the execution.
So here it goes the info about it

The goal of the code:
* To access 288 .xlsx files one by one
* Copy a specific range considering criteria in a filter
* Paste the copied information into a consolidated .xlsx file

The problem: It keeps crashing randomly

The workaround i found: Cut the execution in blocks of 30-40 .xlsx files, only then will it work.

Please Login or Register  to view this content.

Can you guys shed some light in this?
What can i do to improve it or clean it?
What could be the cause of the problem of the random crashes?

Originally Posted by Pepe Le Mokko

On which line does it crash when running the macro step by step ( with the F8 button)?

Well, it doesn't.
When i run it through step by step it doesn't crash.
I think is something related to the memory demanding method of copy+paste

I've developed an entirely different code that loops through every line in each of those 288 .xlsx files to bring out the needed rows, but it takes forever.

Hi,

Maybe move the 'Dim UltimaLinha As Integer' outside the loop
and 'set ArquivoAberto = nothing' so its really empty
remove the 'ArquivoConsolidado.Save' after the if then else where it already is saved in both cases

Grtz