Excel is NOT RESPONDING when copying 4000 files with loop.

Hi all,

Need help here. My excel becomes not responding when the macro copying 4000 files from server with loop method. Any idea to prevent my excel from not responding?

Note: the macro is still running in background even my excel is not responding.

Sample code:

Please Login or Register  to view this content.

Thanks!

Regards,
Ian

That's the message I get with Excel 2003 whenever I'm saving a sizeable file.
I think the message is poorly worded.

When I run code with loops that take a while to complete. I use the
statusbar to indicate what the code is currently doing.
For example:

Please Login or Register  to view this content.