Consulting

Results 1 to 5 of 5

Thread: Solved: MSXML Load and loadXML Methods

  1. #1
    VBAX Regular
    Joined
    May 2007
    Posts
    11
    Location

    Solved: MSXML Load and loadXML Methods

    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?

  2. #2
    VBAX Regular
    Joined
    May 2007
    Posts
    11
    Location
    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

  3. #3
    Moderator VBAX Wizard lucas's Avatar
    Joined
    Jun 2004
    Location
    Tulsa, Oklahoma
    Posts
    7,323
    Location
    Is this to import to Word or Excel...?
    Steve
    "Nearly all men can stand adversity, but if you want to test a man's character, give him power."
    -Abraham Lincoln

  4. #4
    VBAX Regular
    Joined
    May 2007
    Posts
    11
    Location
    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.

  5. #5
    VBAX Regular
    Joined
    May 2007
    Posts
    11
    Location
    Dang it. I just figured it out.

    xmlDoc As DOMDocument

    is not the same as

    xmlDoc As New DOMDocument

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •