Michael Paravicini
asked on
XML in VBA
I am using XML in vba but not sure how to represent the following code:
<InstdAmt Ccy="CHF">15.00</InstdAmt>
I am currently using:
Set NodeAmt = doc.createNode(NODE_ELEMEN T, "Amt", nmsp)
NodeCdtTrfTxInf.appendChil d NodeAmt
Set NodeInstdAmtCcy = doc.createNode(NODE_ELEMEN T, "InstdAmtCcy", nmsp)
NodeAmt.appendChild NodeInstdAmtCcy
NodeInstdAmtCcy.Text = Nz(rst!Ccy)
Set NodeInstdAmt = doc.createNode(NODE_ELEMEN T, "InstdAmt", nmsp)
NodeAmt.appendChild NodeInstdAmt
NodeInstdAmt.Text = rst!PayAmt
which obviously is wrong. Any help is really greatly appreciated... Thanks Michael
<InstdAmt Ccy="CHF">15.00</InstdAmt>
I am currently using:
Set NodeAmt = doc.createNode(NODE_ELEMEN
NodeCdtTrfTxInf.appendChil
Set NodeInstdAmtCcy = doc.createNode(NODE_ELEMEN
NodeAmt.appendChild NodeInstdAmtCcy
NodeInstdAmtCcy.Text = Nz(rst!Ccy)
Set NodeInstdAmt = doc.createNode(NODE_ELEMEN
NodeAmt.appendChild NodeInstdAmt
NodeInstdAmt.Text = rst!PayAmt
which obviously is wrong. Any help is really greatly appreciated... Thanks Michael
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER