Thanks. I will try it.

"Ron de Bruin" wrote:

Hi Ayo

See
http://support.microsoft.com/kb/210684/en-us



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ayo" wrote in message ...
I keep getting this "Error 1004 Copy method of worksheet class failed" and it
is not consistent. I am running a macro that open a file in a folder and
extract data from it to be place in another file. The macro runs fine until I
get this error. It doesn't occur at the place, meaning the same file doesn't
trigger it al the time, hence the inconsistency. I can't figure out why it is
stopping. There are 286 files in the folder but the error occurs after the
245th file.
Please help.