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" wrote in message
...
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