Saving an excel file with the same name and same location after updating few columns

[Ankesh]

You need to disable the display alert option.

Use the below code

Code:

Set objexcel=createobject("excel.application")
Set objworkbook=objexcel.Workbooks.Open("C:\test.xls")
Set objworksheet1=objworkbook.worksheets("test")

objexcel.DisplayAlerts=False 'This will not display any popup

objWorksheet1.cells(Row,Column)=Value
objexcel.objworkbook.save

Regards,
Ankesh