>>A UNC requires there to be a sharename following the server, not a necessarily >a volume name.
>
>>so it would be "\\server\sharename\folder\filename.xls"
>
>Hi Fred
>
>Thanks for the response however our volume has been set up as a share with the same name. The code works fine on machines which are running office 97.
>
>After further investigation it appears the behaviour of SaveAs has changed in Excel 2003, in that you can't overwite your open file even to update it to the latest version.
>
>Any further thoughts?
Can't try that at the moment, but is there a way to just .Save() and change format at the same time? It may have a parameter for that.