VBA Code to Open/Edit XML File

[Stan Denman]

I am very new to programming, so be gentle! I want to open and edit an xml file that will be the source of data for a pdf form. the data I want to use to edit the xml file is in MS Access. Trying to take this one step at a time, I am trying to open and edit an xml file via vba code. The following code throws a runtime error code 91. I don't understand why. I do have a reference to "Microsoft XML, v6.0"



Private Sub Command0_Click()


Dim xmlDoc As MSXML2.DOMDocument60
Dim xmlNew As MSXML2.DOMDocument60


xmlDoc.loadXML ("C:\users\stand\documents\contactlist.xml")


End Sub

[Micron]

The clue is in the message statement: Object variable or With block variable not set.
When you declare an object variable, you must use the SET statement to tell Access to put that object in the memory space you've allocated with the Dim statement.
Set xmlDoc = "C:\users\stand\documents\contactlist.xml"
Then you can perform actions on it.

[Stan Denman]

Thanks for your help. Now I get a type mismatch error with the Set statement.

[Micron]

I know virtually nothing about the xml object model, so I'm afraid I won't be of much help beyond what I could do by Googling the subject, which I imagine you could do without me misguiding you. I will take one last stab though:
Dim xmldoc As New DOMDocument60
xmldoc.Load "C:\users\stand\documents\contactlist.xml"