How to know what inspect element wording to use with website dropdown

[Sintek]

Hi All

I am trying to automate client payments...The code below does all accept for two parts as depicted as Part1 and Part2

Please Login or Register  to view this content.

The below images are the inspect element view of the specific elements needed for Part1 & Part2

[Sintek]

............deleted....................

[Sintek]

Hi All

I have reopened this thread as I need help with specific inspect element extraction...

Okay, so I found the code to press pay....

Please Login or Register  to view this content.

[Sintek]

Any ideas what code I can use to select the first option of the dropdown box
.

Please Login or Register  to view this content.

[daboho]

Use as colection because so many choice
Like in sheets
For each sh in sheets
Also in dropdown

Please Login or Register  to view this content.

[Sintek]

Hi daboho

Thanks for response...Am getting an error 438, object does not support this property or method

[daboho]

I am not test but if you
Want select dropdown in web
And dropdown object is as colection
You must to add reference tool
Xml html and xml

[Sintek]

Am I using the correct extraction from inspect element as per image above in post 1...References have been added

Please Login or Register  to view this content.

[CK76]

FYI - getElemnt(s)byxxx has some quirks if reference to the library (HTML Object) isn't added.

In many cases only reliable method without reference is to access by TagName or ID.

As for selecting from drop down. You can loop through length of object and check instr for value you are after.
However, in most cases, you'd not set the value, but set selected = true.

Ex:

Please Login or Register  to view this content.

[daboho]

I am not understand what you want
My english is bad but propertis in dropdown or other object same as like in sheet

[Sintek]

My question is as follows....
With this code

Please Login or Register  to view this content.

looking at the HTML code of the dropbox in post 1...What goes in place of the red part above...

[Sintek]

@CK76 Thanks for your response...Same error 438

[daboho]

Yes i am agree
But if still using loop
Can do using UDF for eficiency
And if you want loop
Dim op as object
Dim op1 as new ihtmlelementcollection
set op =....getelementsbyclassname("blababa")
Set op1= op.getElementsbyID("blababa")(0)
And loop op1

[CK76]

From the screen shot you provided, try "fromAccount_dropID".

But it's difficult to pinpoint the control needed without seeing site in action. Since there could be more than one drop down and often, there is script associated to dropdown selection.

In that case, you'll need another line to fire the script.

Typically something like below to fire JS event.

Please Login or Register  to view this content.

[Sintek]

There is only 1 dropdown...I have ticked the reference HTML library...
Errors on this line...

Please Login or Register  to view this content.

Dropdown has choice of "Business Account" or "Personal Account"

[CK76]

From your screenshot, "fromAccount_parent" is a wrapper and not the dropdown itself.

Try either "fromAccount" or "fromAccount_dropID".

0.JPG

[Sintek]

@ CK76 tried both options....still errors, now on red line of code

Please Login or Register  to view this content.

[daboho]

After id has matches
Try this

Please Login or Register  to view this content.

[CK76]

What's the error message and what value does obj.Length return?

[Sintek]

@CK76...
Error 438, object does not support this property or method ...
No values returned..errors prior

@ daboho...
I do not understand...What do i replace the red part with

Please Login or Register  to view this content.

Edit...i feel like i felt 2 years ago when I had no clue how to use excel...A complete newbie...
This is current code...

Please Login or Register  to view this content.

[daboho]

I think your problem is
How to find correct id
I think you easy to use HTTPRequest
And download add on for google ( i am forget is name)
To record like record makro
This add on can do search what you want

[Sintek]

I clicked on the dropdown and this is the code for the options...Will this help?

Untitled.png

[Sintek]

daboha & CK76...Thanks for your patience..
Got it working with the following code:

Please Login or Register  to view this content.

[CK76]

So try looping through <li> tag or using class "dropdown-item clearfix".

But as previously stated, it's pretty difficult to trouble shoot web scraping code, especially when you are piloting browser, without actually seeing site in action to trace everything that goes on a given site.

Edit: Glad you got it working

[Sintek]

Guys....Surely it can't be this difficult to grasp....
Herewith image of logout button HTml

Once again...I have tried everything and can't get the logoff button to click...
I mean really!!!!!!

logout html.png

[CK76]

You'd either access it by ClassName or TagName.

ex.

Please Login or Register  to view this content.

Note that since both are ElementsCollection, you'd need to specify index#.

[Sintek]

And back to same error message with both options...Error 438, object does not support this property or method ...

Darn it CK76...why can't I wrap my head around this stuff...


Edit...
I stand corrected ....This does work...I did not have application.wait code in place for screen to finish loading...

Please Login or Register  to view this content.

thanks CK76....Any helpful links you know of thatIcan study...why the (0)

[CK76]

Web scraping is learning how to read developer tools and html source code. Has very little to do with VBA knowledge, once you get the basic DOM structure.

Try instead of using Inspect Element, see if you can locate the button in the source code.

Since every site has it's own style and structure, it's largely trial and error. With experience, you get better at spotting the right element to access info/action needed.

Edit: Glad, you got it working. (0) is first item in Element Collection. It's standard method to access first element in array/collection.

Edit2: .getElementsByClassName as the method name suggest, returns elements, hence the need to specify which element you are interacting with.

[Sintek]

Got it...Time for google lol...Thanks again CK76

[Sintek]

CK76...last one...I promise....Such a lot of variations within the HTML code
Untitled.png

[CK76]

This is <a> tag (i.e. Hyperlink).

But, has code that fires onclick. Try something like below to fire script without need to simulate click on element.

Please Login or Register  to view this content.

Replace "fnb...; return false;" part with full string in quote after onclick=.

If that does not work, you'll need to .getElementsbyTagName("a") and set it to some object variable. Then loop through the collection and identify if href has "#" as it's value. If it does, you can fire script using .FireEvent on object.

Ex:

Please Login or Register  to view this content.

Note that this is provided there are no other <a> tag with href="#".

Edit: Alternately you can check objHL.innerText = "Confirm" (or use INSTR function).

Edit2: Forgot to add index to objHL. Updated code

[Sintek]

k tx will try and advise...

[Sintek]

Have tried all three suggestions and error 438 occurs... This is the last step in my code that has taken 3 days lol...

[CK76]

I forgot to add (i) to objHL. Try it with that.

[Sintek]

Tx ... Have used following and when i = 2 it returns "Confirm", however, it bypasses the FireEvent

Please Login or Register  to view this content.

[CK76]

Hmm, then try just simulating click and see what happens.

Please Login or Register  to view this content.

[Sintek]

That was the first thing I tried...So close yet so far.....

[Sintek]

Okay, there was a trailing space in "Confirm ", so it now returns true but the

Please Login or Register  to view this content.

does nothing

[CK76]

Hmm, if you can upload full source html for the page (as text file), it may help. I have suspicion that there may be more than one .innerText = "confirm".

[Sintek]

How would I do that...

[Sintek]

This is tricky stuff man.....This solves ....

Please Login or Register  to view this content.

[CK76]

So there's some nested (child) element within the obj that you are looping through.

For web scraping, understanding HTML structure along with few other things is more important than knowing VBA

I'd recommend going over W3School's documentation.

[Sintek]

will do...Tx again

[CK76]

FYI - Here's code that I use to export Document.Body.innerHTML to text file.

Assuming you've already navigated to the page that you need and set IE object.

Please Login or Register  to view this content.