The code I have (which works, apart from the slow down) is Īpplication.Calculation = xlCalculationManual If the memory is getting less as the file progresses, that would explain the slow down as it gets further in? We need to use the method that pgc01 gave us about to give us the correct file format, but I was wondering if the file that is been created is actually held in memory until the final 'SaveToFile' This however allowed us to notice something else, the further down the list it gets, the slower it gets, it starts off at a fairly rapid pace but after a while it starts to slow down to 1 record per second and gets worse from there. When we started it used to take an hour or two, but now it's getting more like 8 when it's working with 164,000 rows :/Īs it was getting to the point where we weren't sure if it was actually doing anything I've put a ticker on the Status Bar that lets us know which row number it is up to so we know it's still working as there was some doubt the first couple of times it got past the three hour mark. We've got this up and running now thanks to the info above, however we've become to increasingly rely on it and the data sets involved have gotten bigger and bigger and it's taking longer and longer to run. Apologies about bumping the thread, but I've another question about this and to save explaining again.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |