Quote Originally Posted by p45cal View Post
Your last attachment works fine here. You'll have to wait a bit.
If you want to reassure yourself that it's working, change the line:
ResultBlockSize = 1000000
to say:
ResultBlockSize = 100000
which should produce some 24 new workbooks with your data.

I'm presuming the file I attached to msg#58 worked OK.
Yes, you are right. I waited for 6 minutes to generate 3 workbooks. Is it possible to improve the speed without decreasing the ResultBlockSize?