Apologies if this has already been asked and answered. Struggling to find an answer.
We have an internal system that only works through Internet Explorer (I know!).
The particular page I need is just one line of basic text.
I need to open the relevant URL (let's say it's in Cell A1) copy the text and paste it in to cell B1, then close IE.
This is the format of the data on each page:
<html xmlns:e="ADDRESS REMOVE" xmlns:s="ADDRESSREMOVED">
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<link rel="stylesheet" type="text/css" href="Bin.css">
</head>
<body>
<table width="40%">
<tr>
<td>NOT allowed at this property</td>
</tr>
</table>
</body>
</html>
I just need to return the data between <td> & </td>, so NOT allowed at this property
Thanks in advance!
We have an internal system that only works through Internet Explorer (I know!).
The particular page I need is just one line of basic text.
I need to open the relevant URL (let's say it's in Cell A1) copy the text and paste it in to cell B1, then close IE.
This is the format of the data on each page:
<html xmlns:e="ADDRESS REMOVE" xmlns:s="ADDRESSREMOVED">
<head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-16">
<link rel="stylesheet" type="text/css" href="Bin.css">
</head>
<body>
<table width="40%">
<tr>
<td>NOT allowed at this property</td>
</tr>
</table>
</body>
</html>
I just need to return the data between <td> & </td>, so NOT allowed at this property
Thanks in advance!