How do I get a value from an xml file with vba?

[ucchris77]

I am trying to learn how to use xml with vba. I want to get the value of the "Location" element in my xml file. When I run my code I get the error "Error 91, Object Variable or With not set." Below is my VBA code and my xml file. I have also made a reference to MSXML 6.0. Thanks!

Please Login or Register  to view this content.

Here's my xml code.

Please Login or Register  to view this content.

[ucchris77]

Never mind, I figured it out. I was doing this completely wrong.

[royUK]

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save