PDA

View Full Version : Solved: MSXML Load and loadXML Methods



adenter
05-14-2007, 09:34 AM
This seems like it should just work so I am frustrated with myself that I can't RTFM my way through this. I am failing to get a good response when using either the load or loadXML methods. I have tried to pull in a file that is properly formatted (UTF-8) and a proper fragment. In each case it seems to just hang the script without an error. I have built simple If/Then loops to catch a boolean error. I am getting nothing.

Any ideas of what I could be missing?

adenter
05-14-2007, 10:16 AM
If xmlDoc.loadXML("<customer><first_name>Joe</first_name><last_name>Smith</last_name></customer>") Then
MsgBox "Success"
Else
MsgBox "Failure"
End If

This is what I am attempting. I don't get a MsgBox. Nothing

lucas
05-14-2007, 10:20 AM
Is this to import to Word or Excel...?

adenter
05-14-2007, 10:23 AM
End result I am working with Outlook. This seemed like a generic issue because I can put stop points along the script to determine it moves until I get to the loadXML.

adenter
05-14-2007, 10:40 AM
Dang it. I just figured it out.

xmlDoc As DOMDocument

is not the same as

xmlDoc As New DOMDocument