XML parsing & Object variable not set (Error 91)

tinfanide · #1 12-29-2011, 08:43 AM

Unknown error:
Object variable not set (Error 91)

Even after looking at the help document, I cannot figure out why the codes are wrong:

xmlParsing-error(ObjectVariableNotSet).zip
Please see my attachment. Thanks!

Code:

Sub loadXML()

Dim xmlDoc As MSXML2.DOMDocument
Set xmlDoc = CreateObject("MSXML2.DOMDocument.3.0")
xmlDoc.Load ("C:\Users\Tin\Desktop\teacher_halloween.xml")

Dim r As Integer
r = 1
Do
For v = 0 To xmlDoc.getElementsByTagName("Value").Length Step 3
    Cells(r, 1).Value = xmlDoc.getElementsByTagName("Value")(v).Text
    r = r + 1
Next v
Loop Until r = xmlDoc.getElementsByTagName("Time").Length - 1

Set xmlDoc = Nothing
End Sub

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Application-defined or Object-defined error	Manit	Excel Programming	4	12-08-2011 07:35 PM
Multi-Variable Lookup help	ebolton	Excel	8	05-05-2011 05:28 AM
Variable fields?	Emalee77	PowerPoint	0	01-30-2011 05:58 PM
Problem: object library invalid or contains references to object definitions	aligahk06	Office	0	08-19-2010 12:29 PM
Could not load this object as this object is not present in your computer	k.gaurav	Office	0	08-17-2009 09:57 PM