I have an excel spreadsheet that uses the document.getelementbyid("Place id here"). I think it is throwing an error because on the page I am trying to grab information from there are two id's that are the exact same. What can be done to keep this from erroring out?
I think IDs are unique, so it can not be duplicate.
I have an example of a page with duplicates. There are two elements with the id "dealTitleLink". The page is http://www.amazon.com/gp/goldbox
When I search on the source code, dealTitleLink returns zero.
If you go the the page right click and inspect an element and then search. There are two of them.
I don't think it is the duplicate that is throwing this error anymore. I am getting a type mismatch error after this line of code. Set a = ie.Document.getelementbyid("dealTitleLink"). Microsoft says that if there are duplicate id's then it will just return the first one. Any other ideas on what might be causing this?
What's a dimmed as?
Here is the code up to that point.
Sub getDealOfTheDay() Dim promoTitle$, promoLink$, a 'inbetween here I have code that opens internet explorer openPage "http://www.amazon.com/gp/goldbox/", ie Set a = ie.Document.getelementbyid("dealTitleLink")
Last edited by manofcheese; 08-31-2015 at 02:32 PM.
Where's the rest of it? Are you sure you've allowed sufficient time for the page to finish loading before trying to get the element?
In the rest of the code it loops through to add more time until the whole page has loaded. This was working fine last week and then it just broke when I opened it today. Have there been any microsoft updates recently that might affect this?
It's far more likely that Amazon have changed their page, however without you posting your full code there's very little we can do to help, if you post it, I'm happy to take a look
In fact, I don't have any id of dealTitleLink in that page
Example.PNG
This is what I am able to see
It looks like it is changed in Internet Explorer but in Chrome it is still the same. Any suggestions on how to pull that same data?
Hi,
in case of duplicates ID (not often but I yet met several times) in same window or form,
getElementById returns a collection … So you can separate each one by index as item(0), item(1) …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks