Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

NSLOOKUP

I am trying to do NSLOOKUP and get the server information back.It works but it replies only first two rows of the result.

Please let me know if there is any error in the code??

sub nslookup()

set TableBox = ActiveDocument.GetSheetObject( "TB02" )
for rij = 1 to TableBox.GetRowCount-1
cell = TableBox.GetCell(rij,0).text
Set objShell = CreateObject("WScript.Shell")
Set objExec = objShell.Exec("nslookup -n 2" & cell)
strPingResults = LCase(objExec.StdOut.ReadAll)
TableBox.SetInputFieldCell rij-1,3,strPingResults
'msgbox(strPingResults)

next
end sub

REGARDS

Priya

Community Browser