>>>>>>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.
>Sanjay,
>Just replied for overwrite. Doesn't sure about the value but should be ox.saveas(cFilename,1) && Overwrite
>Cetin
Thanks Cetin. It was a while ago since I did that. I do seem to remember that there was some conversion (?) problem with sending the 'overwrite' parameter through, although I am not sure.
Sanjay Kapoor
Relatively speaking is a conversation with Einstein