SaveCopyAs

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

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

SaveCopyAs will save it as an exact copy.

So you could do your .savecopyAs, then open it, save it the way you want and the
close it.



Mark wrote:
>
> 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

--

Dave Peterson