I have a problem with Sdd = Trim(DOC.getElementsByTagName("balls").innerText) not working says method not supportedPlease Login or Register to view this content.
Any ideas will be greatly appreciated
Thank you for your time
I have a problem with Sdd = Trim(DOC.getElementsByTagName("balls").innerText) not working says method not supportedPlease Login or Register to view this content.
Any ideas will be greatly appreciated
Thank you for your time
GetElementsByTagName return a collection of elements. InnerText is a property of a individual element.
So you first need to get the collection and then loop thru the collection to get to the individual elements.
The code below gives you something like that. Notice that also a lot of CrLf's are returned. Replaced the by spaces.
Elements are dumped to the active sheet. Change that to yr needs.
Please Login or Register to view this content.
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
Hello thank you for your help, it seems to put the data all in 1 cell and the words supp are present.
Is there anyway to match the date or draw no to my pre filled data I have the date starting in B5:B? and the draw no in C5:C?, then paste the data 1st no in D5 (Or whatever row that matches the date of draw) 2nd in E5 and so on i have the Headings in the previous row to row 5 so would not need the supp word that comes from the website.
Thank you for your help i find this very interesting.
This piece of code extracts the results from the site and puts them into separate cells.
Ofcourse it's very specific for this webpage.
Just alter the cells the results go to your needs.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks