GetElementById vba issue

Hi Guys...

Have come along way with web scraping but am stuck on one certain element...Can anyone perhaps assist...
In below images the highlighted yellow Dropdown has 4 selections
I require selection 4
below is some of the code I have tried...None works...
Image1.png
Image2.png
Image3.png

Please Login or Register  to view this content.

Please Login or Register  to view this content.

getElementsByName returns a collection of elements, to work with a specific element in the collection you need to specify which one you want.

Hi Norie

Tx for your response... How would I establish that from the html inspection image above...

So this code errors as Run-time error 424 Object required

Please Login or Register  to view this content.

Really having a hard time grasping this stuff man...

Thanks for sticking by me Kyle123

Page has finished loading...Herewith page screenshot and 2 level element html
Image1.png

Image3.png

Above is For Report Fields


Image2.png

Above is for Performance

I am stepping through code...not running so I wait for all screens to finish loading...

Please Login or Register  to view this content.

Have tried that as per Post 5

Untitled.png

Doesn't get that far as it errors...Kyle do you know of any links I can check out to try and understand this stuff...

So this code errors as Run-time error 424 Object required

Please Login or Register  to view this content.

IE does not allow me to inspect that element even when I use Firebug.

unless you post the actual html

How would one do this?

sintek, have you tried adding reference to HTML Object Library & Internet Controls?

I'd recommend doing this. There are some oddities in these libraries, that getElement(s)Byxxx method misbehaves.
Also, it's good idea to declare objects explicitly in HTML as single element can have multiple type of objects belonging to it (ex. childnode, Tag etc).

But if possible, using Developer Tool, trace what request is sent to sever when you makes selections and submit.
Then use xmlhttp or winhttp to send "GET" or "POST" request to the sever with appropriate headers and request string.

Hi CK76

Both are ticked...This is the 18th and second last step in my report extraction and darn I'm stuck...

But if possible, using Developer Tool, trace what request is sent to sever when you makes selections and submit.
Then use xmlhttp or winhttp to send "GET" or "POST" request to the sever with appropriate headers and request string.

This is Greek to me lol...

Looking at the images of the inspect element is there anything that stands out that has to be set prior to

Please Login or Register  to view this content.

Freak-in amazing......10 hours and i still can't get one line of code to work WTF

Something that might be important????
In below code, the red part opens another page...

Please Login or Register  to view this content.

End Sub

In that case wait until the page is loaded. So after the obj.Click add the following lines...

Please Login or Register  to view this content.

Or this...

Please Login or Register  to view this content.

Hi sktneer

Thanks for joining in...I am stepping through the code and am waiting for page to fully load before next step...

After the new page is loaded completely, the element with id "lblCustomReportBuilder" exists as per the html document?

Yes it does

Untitled.png

The highlighted line is h1 tag with id title not the id lblCustomReportBuilder.
What I am missing here?

I see. The element you are interested in has the id 'PerformancePeriodStepType" but that's not visible either in the image you posted.

I really don't know sob sob sob

This is Main Page prior to clicking Report Builder
Main page.png

This is the inspect element of Report Builder button
ButtonClick.png

This is Next Page that opens...
Image1.png

This is inspect element of dropdown box
Button inspectElement.png

Does it just navigate to new page, or does it open another page in new tab/window?

Opens another page in a new tab window...Not a website it is an server that allows for report statistical information extraction...

Same site two different pages...It is basically a form that opens up...
https://analytics.financialexpress.net/Default.aspx#
https://analytics.financialexpress.n...leBuilder.aspx

Have to step out..Will carry on trying again tomorrow...I am certain that it is something so simple....


@ Norie, Kyle123, sktneer, CK76
Thanks for all your input so far guys...

Morning All

Yesterday was one of those days where i wanted to pull out my hair lol...
I understand that I need to somehow get access to the pop up page prior to access to the dropdown button...
This is the inspect element of that pop up page...What can i make use of to set focus to that page?

PoPUp Form element.png

Hi Sintek,

Sorry! I am not able to help.
I had a similar issue with the login method on a website where after clicking the Login button, a new popup window popped up for user to fill the username, password and a submit button to login on the website. And then after filling the username and password, I was unable to click the submit button as it was greyed out after filling the inpuboxes programmatically. In that case, the address of the IE also changed and what I did then I used the changed address for IE to navigate and accessed the html document. See if something similar happens in your case after popup window appears.

Morning sktneer

That is definitely the case...I need to set focus to the new pop up window before getting access to the element id...
Found some code which is supposed to do this but having difficulty getting it to work as it renders "" results

Please Login or Register  to view this content.

What's the IE address when the popup window appears? Is it different from the base url?

Yep...As follows:
analytics.financialexpress.net/Default.aspx
analytics.financialexpress.net/CustomTableBuilder.aspx

So instead of finding and clicking the obj which opens popup window, can you try .Navigate "analytics.financialexpress.net/CustomTableBuilder.aspx" and then try to find the element with the desired id? Just a thought.

Was thinking that could work but unfortunately doesn't *** the code navigates back to Login screen...Seems one can only get that form to popup once logged in...

I meant you need to use .Navigate twice, once for login and another for popup window. Did you try like that?

i.e. replace the following lines (which I guess opens the popup window)

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Yep, that is what I did... It unfortunately navigated to the login screen..

Alrighty then... Think we getting somewhere...This worked perfectly the first two times but then an error came up after 3rd time testing...

Please Login or Register  to view this content.

Error_Msg.png

Hey guys...The original problem was solved, so i am gonna mark as such...Thank you all once again...
I will open a new thread with error...

You're welcome Sintek! Glad your original issue got resolved.
Thanks for the rep.