> I have tried the code, I am stuck at Dim X As MSXML.XMLHTTPRequest
which states User defined type not define, I have set References in
the VBA Editor to Microsoft XML v2.6 as I cant find Microsoft XML v2.0

I am not sure what I have done wrong. Pls assist as I want to learn
how to do this.

Thanks for your patience.