I am trying to use these codes to add some values in a cell without opening an excel sheet and closing it-
f1:: Xl := ComObjCreate("Excel.Application") Xl.Workbooks.Open("c:\Users\Manoj Aggarwal\Desktop\DATA.xlsx") Xl.Visible := False Xl.Range("b1").Value:= "jaisiaramji" Workbooks.Save() Workbooks.Quit() Workbooks:=""
They are working but when I manually open that excel sheet it pops up massages that DATA.xlsx is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen DATA.xlsx.
Kindly help me and suggest me what modification I have to make in codes. Thanks.