Probably because you have a name conflict and it is finding the wrong file
or you have a duplicate name in your data.

If it is the first thing, the simple code I gave you would not have that
problem. If the latter, then you need to clean up your data.

--
Regards,
Tom Ogilvy

"saybut " wrote in message
...
Hi Bob, thanks very much for showing me that. it seems to work perfect,
the only problem I have is that it doesnt seem to know when to finish
so I get a Run-time error '58' File Already exsists. It appears that it
can't rename the last file for some reason.

I'mm sure if I play about with it enough I should be able to figure it
out.

Thanks a lot for the help.

Regards,

Mark.


---
Message posted from http://www.ExcelForum.com/