my skills are few, but i created a database of my home movie collection. I use Infuse on Apple TV. With "infuses" xml format i can display meta data. But their format (i don't think) fits a schema. could some one point me down a VBA path that would essentially allow me to to export a query of a single record in this xml format. ive seen people mention "hardcode" VBA but cant get far into it to fit my need, if that will even fit the need? Thanks for the guidance in advance!!
XML:
<media type="Movie">
<title>NEW FOUND PENN FOOTAGE 2017</title>
<description>Penn takes dads phone and makes a movie. His camera work needs a little help.</description>
<rating>G</rating>
<userStarRating>9</userStarRating>
<published>2017-10-28</published>
<genres>
<genre>Family</genre>
<genre>Penn</genre>
</genres>
<cast>
<name>Penn Tiburzi</name>
<name>Marla Tiburzi</name>
<name>Trevor Tiburzi</name>
</cast>
<producers>
<name>Tiboziol Family</name>
</producers>
<directors>
<name>Penn Tiburzi</name>
</directors>
</media>