Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using a macro to update the value in an excel and later reading the resulted updates from QlikView script. But it's not working.
The values are not getting updated in excel.
Can someone tell me what I am doing wrong here?
the code is taken from one of the answers in the community.
Function excelFormulaReader(file,value_submit)
set objExcel = CreateObject("Excel.application")
objExcel.DisplayAlerts = False
set objWB = objExcel.Workbooks.Open(file)
With objWB.Worksheets(1)
.Activate
.Cells(1,1).Value = value_submit
End With
objExcel.save
objExcel.quit
set objSheet = Nothing
set objWB = Nothing
set objExcel = Nothing
end function
and I am calling this from script using
let value = excelFormulaReader("path",'value to be inserted')
thanks in advance
Found the issue. It worked when the security is changed to system Access.
Found the issue. It worked when the security is changed to system Access.