All Questions
143 questions
0
votes
1
answer
66
views
Excel VBA : Element not found ---> NoSuchElementError
I am trying to automate web browsing using Excel VBA, with Seleinum Web driver. I am in first step in navigating the website, and I stuck. I am not able to find the element for the username and ...
0
votes
0
answers
99
views
Save a captcha image or take screenshot from website with VBA SeleniumBasic
I need to save a captcha image locally from a website but I haven't been able to do it. I have made some progress with my code but not completely.
I'm trying to take a screenshot of a website's ...
- 15
2
votes
0
answers
179
views
VBA Selenium SendKeys Ctrl+C not working on Chrome Browser
I have tried all options and searched but not found VBA code for Chrome Selenium .
I am trying below code:
Please suggest what is missing in the code.
Private keys As New selenium.keys
Private driver ...
0
votes
1
answer
128
views
VBA Selenium - Text not pulling through from Xpath
I have written some VBA code to pull out some stats from a webpage. Almost all of it pulls through, but the name of the player is the only bit of information that is not being returned. I've tried the ...
- 3
0
votes
1
answer
520
views
Selenium VBA: Get the table content which are having <div class elements under <tr and <td
I want to extract the table content from the following HTML code which are listed under <div class. I tried with different codes but i couldn't find the correct solution.
<table class="...
- 71
0
votes
0
answers
94
views
Web Scrape click button with Chrome Selenium on short VBA code
My Goal is to click Submit Button(Here in Korea) of URL below.
"https://datacentersupport.lenovo.com/us/ko/warrantylookup#/".
The VBA source code puts "j30a7xlg" using Sendkeys ...
- 21
0
votes
0
answers
613
views
Selenium VBA Error Handling For Run-time error '7': NoSuchElementError
I have just finished writing my first MS Access VBA web scrape that feeds from an Access form into a CMS Web Portal form, First & Last Name, DOB, SSN, and then reads back the MBI data to Access. ...
0
votes
0
answers
29
views
VBA Web Scraper Only Works on First Column [duplicate]
I recently developed a web scraper that uses VBA and Selenium. The purpose of the macro is to go through all of the links in every row in the first column in Sheet1, scrape the web content, send the ...
- 1
0
votes
1
answer
277
views
How to find a webelement by a part of an href / url using selenium VBA
I am trying to find a web element by (a part of) a URL using Selenium VBA.
I know we can find web elements using
driver.findelementbyxpath('//a[@href="'+url+'"]')
However, this only works ...
- 1
0
votes
1
answer
85
views
Automate the Page using Selenium VBA "https://wideo.co/text-to-speech/"
I want to download mp3 from the website "https://wideo.co/text-to-speech/"
But I unable to get the Elements from this website. Neither tag nor Name works.
Sub wideoAutomate()
Dim obj As ...
1
vote
2
answers
566
views
How to get Amazon Product price using VBA selenium and save in a cell
I have a VBA script that scrapes product title and price into an excel sheet. I am using SeleniumWrapper library to get the links from Column A and scrape the Amazon product urls row by row. Row1 ...
1
vote
0
answers
263
views
Using VBA SeleniumBasic, how can I define the HTML source within a frame in a similar way to the Microsoft HTML Object Library?
Since Internet Explorer was completely disabled, a lot of VBA code I had written involving webscraping has become completely useless, and that required using Microsoft Internet Controls along with ...
- 11
0
votes
1
answer
552
views
Selenium vba: Found Multiple elements with same Class Name (pulling incorrect table details)
Team, I have a code which previously pulled table data correctly, now the webpage have been updated with several codes hence it result in pulling different table data in between my work.
I need to ...
- 71
1
vote
1
answer
576
views
VBA & Selenium | Access iframe within HTML containing #document
I am trying to access the HTML within two iframes using Selenium Basic in VBA, as IE has been blocked on our machines, and Python, etc. are not available to us.
Previously I could access the html with ...
- 75
0
votes
2
answers
552
views
VBA Selenium: How to Extract <!-- p> non-displayed comment text, from a Web Page Element
I am doing a county property survey. The mailing address is included on each record/webpage as a non-displayed comment <!-- p> with a p tag I am trying to extract those non non-displayed ...
- 55