Speeding up VBA

Hi all,

I used this code a couple of weeks back without a problem, however, when I run the code now (to import text files of over 1.8m rows) it runs much much more slowly. I was previously able to import a file in 5-10 minutes, yet now I've calculated that this could take around a year at this rate!! I was wondering if there's something in the code which is causing it to get stuck, or anything that is unecessary which may be causing it to get hung up.

I don't think it's a computer issue, as I'm running this on a new PC which has 4GB RAM and over 200GB of free HD space.

The code is as follows:

Please Login or Register  to view this content.

I hope you are able to help speed this up and get it back to its optimum!

Many thanks,
smurray444