Javascript creating object issue?

[brasky666]

Not sure if I am referencing correctly or if Javascript is my cause. Here is the code HTML code.

	<div id="Invest">
		

<script type="text/javascript" src="js/functions/scripts.js"></script>	
<div class="content-block">
		<div class="col span-24">
			<div class="col span-11 right-divider">
				<p>
					<label>YYYYYYYY:</label>
					 <span class="value">XXXXXX</span>
					<label>YYYYYYYY:</label> 
					<span class="value">XXXXXX</span>
					<label>YYYYYYYY:</label> 
					<span class="value">XXXXXX</span>
					<label>YYYYYYYY:</label> 
					<span class="value">XXXXXX</span>
					<label>YYYYYYYY:</label> 
					<span class="value">XXXXXX</span>
				</p>

			</div>

When I go to reference the ID tag name, with

IE.Document.getElementsByID("Invest").getElementsByClassName("value")(2).value

it doesn't work. States object does not support method or property. .innertext .text does not work either. How should I reference the value?

Thanks much guys.

[Kyle123]

Getelementsbyid is wrong, should be getelementbyid

[brasky666]

Getelementsbyid is wrong, should be getelementbyid

Thanks... Isthere a method to access via label name?

[Kyle123]

I think you want getelelemtsbytagname if my label you mean element type

[brasky666]

Here is the full VBA. I keep recieving object required. Forgive me as I am new to VBA with HTML so I am learning the syntaxt of HTML. I assume, I am not hitting the HTML doc correctly. Tag vs ID?

Sub Macro2()
  Dim shellWins As ShellWindows
  Dim IE As InternetExplorer
  Dim sIEURL As String
  Dim ACCURL As String
Dim ROWNUM As String
  
  Set shellWins = New ShellWindows
  Set IE = shellWins.Item(0)

ROWNUM = 2

Do While Cells(ROWNUM, 1).Value <> ""

ACCURL = "WEB ADDRESS" & Range("A" & ROWNUM).Value & "#tab9"

sIEURL = IE.LocationURL

IE.Navigate ACCURL
'wait until the page loads
 Do While IE.Busy Or IE.ReadyState <> READYSTATE_COMPLETE
 DoEvents
 Loop

IE.Document.getElementById("investmentCharlesCode")(0).getElementsByClassName("Value")(1).Text

ROWNUM = ROWNUM + 1

Loop

  Set shellWins = Nothing
  Set IE = Nothing
MsgBox "Completed Account List"
End Sub

[Kyle123]

You also will not have multiple results here:

IE.Document.getElementById("investmentCharlesCode")(0)

Get element by ID returns a single element not multiple, so should be:

IE.Document.getElementById("investmentCharlesCode").getElementsByClassName("Value")(1).Text

[brasky666]

Unfortunetely the URL is secure. Has secure info in it. I realize this may be difficult.

Kyle, your second one gets me that the object does not supprt method. I tried value, inner text and recieve the same thing. Thoughts?

[Kyle123]

What's the url?

[Kyle123]

Which version of IE are you using? Earlier ones do not support getElementsByClassName

Without seeing the markup it's impossible to help you any further.

[brasky666]

Given it is 6200 lines of code, I can't post it. And even if I give you the URL, it will block you. So, aside from the HTML/JAVA In the earlier post what info can I give you? Headings? ETC?

[Kyle123]

That was kind of the point I can't help you. - It might be better to do this on an open site whilst you are learning so we can look at the same thing

You didn't say which version of IE you are using.

[brasky666]

Got you. Thanks for the help. IE 9. getElementsByClassName works on a nother script I am using on the site. I know it works. It is the way I am referencing the DIV I am sure. Is there a way to see parents and child nodes easily? I am using developer in IE?

[Kyle123]

Yes, use chrome the developer tools are much better - same principles though. So do your working out in Chrome and then code for IE