Mark,

Use the SaveAs method, where you can specify the file format. SaveCopyAs by default uses the same
format as the file being copied - otherwise, it wouldn't be a copy.

HTH,
Bernie
MS Excel MVP


"Mark" <Mark@discussions.microsoft.com> wrote in message
news:A7845F7D-EDE0-4083-A370-CDB183F089F6@microsoft.com...
> Can someone help please, I am wanting to use the following but with some
> extra code which saves it as EXCEL3 format so that it is compatible with MAC.
>
> ThisWorkbook.SaveCopyAs "C:\Documents and Settings\" & GetUserName &
> "\Desktop\" & "WYP_" & Range("D5").Value & ".xls"
>
> Thanks in advance
>
> Mark