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