Printable View
dear friend,
i am adding comment in my "G4" row using VBA code.becos i am reading from xml.so this is dynamic population.my comment should be like this:
i have 1000 datas. so
karhtik mano padhu mini
mani bani sara msla
daya dei gen millu
like this i need to show in comment.so please how to d olike this please show some sample code for this
I am sorry, I didn't understand. Two questions...Quote:
Originally Posted by karthikeyan
1) How do you decide what goes in the comment for the 1000 piece of data? or
2) Do want the above text to go as comment in all that 1000 piece of data?
please do any one reply me please
Quote:
Originally Posted by karthikeyan
:confused:
koolsid did reply, and asked two questions.Quote:
Originally Posted by karthikeyan
What are the answers to those questions?
dear friends,
i am reading those 1000 values from xml and i have to addcomment in "G4" range and i have to populate those 1000 value in comment as like follows
ex:
karhtik mano padhu mini
mani bani sara msla
daya dei gen millu
there every names are in my xml. i can able to loop through my xml values. but i would like to add comment and pass the reading values in comment like the above example.i think now it is clear.please help me to solve this pl.......
vb Code:
hi, iam looping through the xml to add comment text as follows:
so i have to add reading values from xml in comment inside the loop. i do have 1000 names in my xml.so in comment 4 names per line with some space.so show me some sample code how to do this please help me to write code inside the loopCode:Dim articleDoc As New DOMDocument
Dim NodeList As IXMLDOMNodeList
Dim sectionNode As IXMLDOMNode
Dim rng As String
Dim index As Integer
Dim comment As comment
Dim strcomment As String
Dim lngIndex As Long
Dim lngChild As Long
articleDoc.async = False
articleDoc.validateOnParse = False
articleDoc.preserveWhiteSpace = False
articleDoc.Load strFileName
Set OrgComment = Range("G4").Addcomment("Names")
Set NodeList = articleDoc.selectNodes("//Name")
For Each sectionNode In NodeList
'add values in comment
Next