I have this code to get the response of a url,
Dim request As Object
Set request = CreateObject("MSXML2.XMLHTTP")
m = Range("D7").value
With request
.Open "GET", "https://............./" & m & "&dt=2&d=12&x=&y=", False
.send
MsgBox .responseText
End With
the response Text i get is as below, how to get the x "setLat "and y "setLng" from the javascript code?
<script type=""text/javascript""> function SendChecked() {
var setCity = '';
var setArea = '';
var setLat = '';
var setLng = '';
var setkeyword = '';
if ($('#cityindex').val() != '') { setCity = encodeURI($('#cityindex').val()); }
if ($('#areaindex').val() != '') { setArea = encodeURI($('#areaindex').val()); }
if ($('#latindex').val() != '') { setLat = $('#latindex').val(); }
if ($('#lngindex').val() != '') { setLng = $('#lngindex').val(); }
if ($('#keyword').val() != '') { setkeyword = $('#keyword').val(); }
if (setCity != '' && setArea != '' && setkeyword.indexOf('MRT') == -1) {
location.href = '/region/' + setCity + '/' + setArea + '?q=' + $(""#keyword"").val() + '&dt=2';
}
else {
location.href = ""/information/search?q="" + $(""#keyword"").val();
}
//var setOtherParameter = 'd=24&t=&a=&c=';
//if (setOtherParameter != '') {
// setOtherParameter += '&';
//}
//if ($(""#cityindex"").val() != '') {
// location.href = '/region/' + setCity + '/' + setArea + '?q=' + $(""#keyword"").val() + '&dt=2&x=' + setLat + '&y=' + setLng + setOtherParameter;
//}
//else {
// alert('Please input the address and location');
//}
}