string between 2 strings

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

By Vitosh Posted on March 18, 2022 Posted in Else - Just Tricks, VBA \ Excel Tagged with between substrings, locate, mid, str, string, string between 2 strings, Substring Between 2 Substrings, VBA, xml

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> …

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

Tag: string between 2 strings

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