The frames are just spliting the IE window frame into 3 pieces and i
not the object that contains the text. I would open the webpage withou
the VBA code by typing the URL into an explorer address box. the go t
the developers tool by type F12. there is a search box in the uppe
right corner of the developers tool. Type a string from the portio
webpage that you are looking for into the seatch box. The develope
tool should find where in the webpage the string is located. For som
reason the Search doesn't work when excel is connected to the webpage.
Not sure why
You can also do the same thing using the view - source menu (bu
sometimes you can't find it in the source).
Once you find the string then look for a tag (in angle brackect lik
<abc> or an ID="abc". Look for the tag or the ID before the string yo
are looking for.
You can get the ID object using this. the ID in the source code i
returned from the below statement. You could have the same id occo
multiple times and set varialbe would be an aray.
Set abc = IE.document.getelementbyid("abc")
You can get the tag like this
You can get the tag object using this. The tag in the source code i
returned from the below statement. You could have the same id occo
multiple times and set varialbe would be an aray.
Set abc = IE.document.getelementsbytagname("abc")
Some times the object is a child of the object you are looking for.
often put the SEt variable in a watch window in VBA by hightlighting th
variable (like abc) in the VBA window. then right click the highlighte
variable and select Watch. Press OK in the pop up window. then you ca
press the plus sign in the watch window to see all the properties. I
you don't find the text in the innertext property look for an item an
the end of the properties or lokk at the childnoes. If the object is
table then look under the property rows and to get the columns unde
rows look for cells.
I found case like I mentioned before that the data came from anothe
webpage under the href property. Text cna be found in one of
properties
innertext
innerhtml
outertext
outerhtml.
The case where it came from another webpage the text was put into th
innerhtml property. Instead of pasing the string from the innerhtml i
was easier to go to the 2nd webpage to get the data.
In your case there is an application running which is putting the dat
into the frames. The data is coming from the SU_top.asp, SU_middle.asp
and SU_bottom.asp. You data is propably in the Frame as either th
innerhtml or outerhtml and may not be easily extracted. It would b
better to get a different object which contains the text
