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

SaveCopyAs
 

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

SaveCopyAs
 

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