I am using the methods from the Type-Pool OLE2 to open an excel sheet and Modify it.
And this the code I am using to save the file.
CALL METHOD OF H_EXCEL 'ActiveWorkbook' = H_MAPL.
CALL METHOD OF H_MAPL 'SaveAs' EXPORTING #1 = FNAME.
CALL METHOD OF H_MAPL 'Close'.
CALL METHOD OF H_EXCEL 'Quit'.
Now i want to replace an existing file with the new data. When I save it in the background I donot want the prompt
saying that "The file already exists in the location.Do you want to replace it?"
I want it to directly replace it.Can someone tell me how to do that?
Thank You,
Shashi Devi.