Hi all,

I am using following code to create a excel file and save details ..

want to know the parameter required in order to OVERRIGHT the file. at present it is asking for overright the file.


Set ExcelApp = CreateObject("Excel.Application")
Set ExcelSheet = CreateObject("Excel.Sheet")
--------------
----------------
ExcelSheet.SaveAs FileName

ExcelSheet.Application.Quit
Set ExcelSheet = Nothing

Thanks in advance



It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha

__________________
It is always safe to assume, not that the old way is wrong, but that there may be a better way...
*************************
Rekha