Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveCopyAs with a twist | Excel Discussion (Misc queries) | |||
savecopyas question | Excel Programming | |||
saveCopyAs | Excel Programming | |||
SaveCopyAs | Excel Programming | |||
SaveCopyAs | Excel Programming |