[pradeep1252]

Hi all,

I am new to this VBA coding. I ve written a prog. to get the data from XML to Excel using macros. I am getting Runtime Error 91, even if i ve set object reference msxml4.dll.
The program runs on other Win 7 OS (Enterprise Edition). Its not working in my system (Win7 home premium).
I dono wats the problem is (Code Error/Adding ref. problem). Below is the code. Please help me in this asap. thanks in advance.

Private Sub Worksheet_Activate()
    Dim File As MSXML2.DOMDocument
    
    Set File = New MSXML2.DOMDocument
    File.Load ("C:\SomeXML.xml")
    Dim name As String
    name = File.SelectSingleNode("page").Attributes.getNamedItem("name").Text
    Cells(1, 1).Value = name
    MsgBox name
End Sub

[raziel_]

perhaps the dll is missing. check if MSXML2 dll version is the same as the one added in your program.

[pradeep1252]

I have added msxml6.dll for the reference. Still the same error..
and my VB version is 6.5.

[BobRodes]

What line are you getting the error on?