>>>>I've created my excel workbook, done what I need to do, now I want to save it as....
>>>>I think I've seen this here before, but I could not find it..
>>>>
>>>>I've tryed several variations of-
>>>>ox=ActiveWorkbook.SaveAs FileName:="C:temp\Book1.xls", FileFormat:=xlNormal,Password:="", WriteResPassword:="", ReadOnlyRecommended:=False,CreateBackup:=False
>>>>
>>>>any help
>>>>
>>>>TIA
>>>>Jeff
>>>
>>>ox.ActiveWorkbook.saveas("C:temp\Book1.xls")
>>>Cetin
>>
>>ox.saveas("C:temp\Book1.xls") is shorter and I think it would be c:\temp...
>>Cetin
>
>Ok got that, and thanks a lot.
>Just for future ref. Can I tell it to overwrite if file already exist ??
>
>thanks again
>
>Jeff
It should be :
ox.saveas("C:temp\Book1.xls",1) I guess. Saveoption is 3 vb constants and taking generally VB constants enumarate as 0,1,.. (Overwrite 2nd option)
Cetin