>>>>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
I ran into problems with existing files with the same filename while using Cetin's oExcel.WorkBooks.SaveAs(filename). The command works like a dream, however, I checked the existence of the same filename in VFP and deleting it before issuing the 'SaveAs' command.

Maybe Cetin or Ed would have a better solution.