SaveCopyAs

[Mark]

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

 

[Bernie Deitrick]

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

 

[Dave Peterson]

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.