View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
Prometheus[_12_] Prometheus[_12_] is offline
external usenet poster
 
Posts: 14
Default Copy & Past from multiple sheets to one

The code completes and reports on 38 files.

The 39th is open but the macro doesn't do anything with it. Funny thing
is taking that file out of the directory allows the macro to get to 103
files, but then the same thing occurs: Taking the 103rd file out of the
directory allows the macro to report on over 150 files and then the
same thing happens with yet another file.

There must be something different about those particular files which is
breaking the macro and sending it to "Cleanup".

I have figured that it's not your macro. Which works wonderfully. Can't
thank you enough.

Cheers
Prometheus