Hi,

if you want simply prevent raising error use on error resume next.

Better way is to check if the filename is already used, have a look at:

http://www.j-walk.com/ss/excel/tips/tip54.htm

regards,
Ivan