Hi, Rob.

>'Invalid path or file name'
>The error was on the line
>'copy to (OutFilename) TYPE XLS'
>Any ideas?

try a

MessageBox(OutFilename)

this way you can see whether the path and file name you´re trying to save is correct.