Skip to Content
0
Former Member
May 28, 2008 at 02:42 PM

Excel Sheet

23 Views

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.