xml – Useful code

VBA – Get Substring Between 2 Substrings – Locate value of Nth XML

Posted on March 18, 2022 by

Vitosh Posted in Just Tricks, VBA \ Excel

Getting N-th string between two substrings might sound a bad idea, until you do not need it. And with VBA, you better have something prepared. So, imagine the following XML (from this article here):

<FootballInfo>
  <row>
    <ID>1</ID>
    <FirstName>Peter</FirstName>
    <LastName>The Keeper</LastName>
    <Club name ="NorthClub">
		<ClubCoach>Pesho</ClubCoach>
		<ClubManager>Partan</ClubManager>
		<ClubEstablishedOn>1994</ClubEstablishedOn>
	</Club>
    <CityID>1</CityID>
  </row>
  <row name="Row2">
    <ID>2</ID>
    <FirstName>Ivan</FirstName>
    <LastName>Mitov</LastName>
    <Club name = "EastClub">
		<ClubCoach>Gosho</ClubCoach>
		<ClubManager>Goshan</ClubManager>
		<ClubEstablishedOn>1889</ClubEstablishedOn>
	</Club>
    <CityID>2</CityID>
  </row>
</FootballInfo>

<row>

<FirstName>Peter</FirstName>

<LastName>The Keeper</LastName>

<ClubCoach>Pesho</ClubCoach>

<ClubManager>Partan</ClubManager>

</Club>

</row>

<LastName>Mitov</LastName>

<ClubCoach>Gosho</ClubCoach>

<ClubManager>Goshan</ClubManager>

</Club>

</row>

</FootballInfo>

Your task is to get…

VBA – Read different levels of XML

Posted on August 11, 2018 by

Vitosh Posted in VBA \ Excel

After the article here for VBA – Select a Single Node XML now I am writing an update from it, which shows how to loop through all the nodes that we are interested in and get data from them. The XML is…

VBA – Select a Single Node XML

Posted on February 19, 2018 by

Vitosh Posted in VBA \ Excel

Selecting and working with XML in Excel and VBA is always a bit challenging. Whenever a programmer (or a developer or an analyst or a portfolio controller) hears about XML and VBA, something weird happens in their minds. The programmer…

Tag: xml

VBA – Get Substring Between 2 Substrings – Locate value of Nth XML

VBA – Read different levels of XML

VBA – Select a Single Node XML