>>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?
>
>William
I haven't noticed that, but I only have 2003 at home. At work, we're still using Excel 2000 and XP (2002) and have never seen that.