Hi,
I am trying to read XML output by using the following procedure and it works except when there is nulls in the "LOCATOR" field. how can i replace the null values ?

For Each myNode In XML.getElementsByTagName("G_1")
i = i + 1
WS.Cells(i + 1, 1) = myNode.SelectNodes("ORGANIZATION_CODE")(0).Text
WS.Cells(i + 1, 2) = myNode.SelectNodes("ITEM_NUMBER")(0).Text
WS.Cells(i + 1, 3) = myNode.SelectNodes("ITEM_DESCRIPTION")(0).Text
WS.Cells(i + 1, 4) = myNode.SelectNodes("PRIMARY_QUANTITY")(0).Text
WS.Cells(i + 1, 5) = myNode.SelectNodes("UNIT_OF_MEASURE")(0).Text
WS.Cells(i + 1, 6) = myNode.SelectNodes("SUBINVENTORY_CODE")(0).Text
WS.Cells(i + 1, 7) = myNode.SelectNodes("LOCATOR")(0).Text


Next myNode