Code running extremely slow (20-30 minutes)

[Biker_Seth]

Hey guys,
I have written a few Macros since my first post on here, and they're working out pretty well. One of these Macros I am trying to run on multiple files. I have a working code but for some reason it takes a massive amount of time to run. Any suggestions or ideas on why it's so slow.
Here it is:

Please Login or Register  to view this content.

[Sintek]

Hi Biker_Seth

I am very certain that we can assist, however, be so kind and upload a sample file and explain to us what you are trying to achieve.

[Biker_Seth]

Hi Biker_Seth

I am very certain that we can assist, however, be so kind and upload a sample file and explain to us what you are trying to achieve.

Thank you, I am trying to loop through a folder full of files like this one, do some processing, and extract the results. Here is an example file.

[Sintek]

I'm curious....How are you performing this code if you have already closed the file...Workbooks(FileItem.Name)

Please Login or Register  to view this content.

What is the reason for this...

Please Login or Register  to view this content.

Have a look at amended code...Might just be a shot in the dark...

Please Login or Register  to view this content.

So difficult not actually knowing what you are trying to achieve...it will be alot easier if we knew exactly step by step what you wanted to do...Also with such a huge amount of data..perhaps autofilter would be a better option.
Perhaps someone else can assist further...