hockeyfanm13
New Member
- Joined
- Feb 9, 2018
- Messages
- 6
Hey all,
I feel like my problem is a lot easier to solve than I think. I've checked Google/Youtube/etc, to no avail.
I'm trying to pull innertext from a tag:
<code>
<td>
******** language="JavaScript" type="text/javascript">
//<![CDATA[
write_value("101",49862);
//]]>
*********>49862
</td>
</code>
My macro results in:
[TABLE="width: 325"]
<tbody>[TR]
[TD="width: 325"]//<![CDATA[ write_value("101",49862); //]]> 49862[/TD]
[/TR]
</tbody>[/TABLE]
I just want the 49862 to appear in the cell. Here is my code:
<code>
ABC = Trim(Total.getElementsByTagName("td")(1).innerText)
BCD = Trim(A.getElementsByTagName("td")(3).innerText)
ActiveCell.Offset(0, 1).Value = ABC
ActiveCell.Offset(0, 2).Value = BCD
</code>
Any thoughts?
I feel like my problem is a lot easier to solve than I think. I've checked Google/Youtube/etc, to no avail.
I'm trying to pull innertext from a tag:
<code>
<td>
******** language="JavaScript" type="text/javascript">
//<![CDATA[
write_value("101",49862);
//]]>
*********>49862
</td>
</code>
My macro results in:
[TABLE="width: 325"]
<tbody>[TR]
[TD="width: 325"]//<![CDATA[ write_value("101",49862); //]]> 49862[/TD]
[/TR]
</tbody>[/TABLE]
I just want the 49862 to appear in the cell. Here is my code:
<code>
ABC = Trim(Total.getElementsByTagName("td")(1).innerText)
BCD = Trim(A.getElementsByTagName("td")(3).innerText)
ActiveCell.Offset(0, 1).Value = ABC
ActiveCell.Offset(0, 2).Value = BCD
</code>
Any thoughts?