JumboCactuar
Well-known Member
- Joined
- Nov 16, 2016
- Messages
- 785
- Office Version
- 365
- Platform
- Windows
Hi,
I have my XML as a string from XMLResponseText
and want to extract certain data?
This to be exact
Just the Filename and URL where the mimetype is PDF
Can anyone help? I think it can be done without parsing if i search the string for application/pdf
Any help appreciated
I have my XML as a string from XMLResponseText
and want to extract certain data?
This to be exact
VBA Code:
<res>
<name/>
<size>67589</size>
<mimetype>application/pdf</mimetype>
<filename>filename.pdf</filename>
<url>http://myurl</url>
<sha256>xxx</sha256>
</res>
Just the Filename and URL where the mimetype is PDF
Can anyone help? I think it can be done without parsing if i search the string for application/pdf
Any help appreciated