All Questions
15 questions
0
votes
0
answers
339
views
VBA coding that will update a website's table data after changing a form input
- Details
I am trying to automate a data scrape from a website in Excel VBA.
The website has a drop-down menu where you can select a location to pull data from.
My VBA code can already grab all the ...
0
votes
0
answers
80
views
Why doesn't GetElementbyId / GetElementbyTagName in VBA work correctly?
my VBA code runs in mood swings
I created a VBA module to get data from 30 html pages and combine them all into a single table in my worksheet. My approach was to loop through each html page one by ...
- 91
1
vote
1
answer
1k
views
Get HTML Table content with VBA for Excel using arrays
Trying to get data from the second table of this website as the first table only contains the elements of a drop list, for whatever reason this is included as a table in the HTML!
The code refers to a ...
- 253
0
votes
0
answers
33
views
Can not Scrape complete html table
I want to get the stock data of the web https://tw.stock.yahoo.com/class-quote?sectorId=4&exchange=TAI.
The vba code is as follows:
Dim objXMLDoc As New MSXML2.XMLHTTP60, objHTMLDoc As New MSHTML....
0
votes
1
answer
499
views
Extracting a Specific Cell from a Table in a Web Page
I am having a subroutine which works well in extracting table from a webpage. I am looking forward to extract a particular inner text in table precisely (3rd Column and 5th Row) in excel worksheet.
...
0
votes
2
answers
215
views
VBA Scraping Tables in JS
i tried to gather every possible solution to get my code working, but unfortunately I am stuck.
I want to scrape the values from two different graphs, which are generated from JavaScript in the ...
1
vote
1
answer
76
views
How can I choose option from this dropdown menu on this website
I am working in vba and trying fill in the form in this website and get the output Link Here
There is a problem when i try to fill in the input box from/to airport. This is what i have tried: This ...
- 23
2
votes
2
answers
163
views
Can't get Web Scraped Table to populate multiple cells VBA
I am trying to scrape a table from a website via VBA. I am able to gather all the data from the table however I am only able to get it to populate a single cell, rather than break out the information ...
- 23
1
vote
1
answer
86
views
How to avoid duplicate information from HTML with .querySelectorAll in VBA?
I am trying to collect data from a website, which stores information about vehicle accidents in the US. For this I need to loop through all the cases on the website and store the tables in an Excel ...
- 70
0
votes
1
answer
337
views
vba: how to insert value within html table?
I can't find a way to pupulate html table clumn, that has a dynamic id -
The id changes everytime I open a new session.
If I manualy populate column(1/10/2019) with "1"(hour) - in the next session ...
2
votes
1
answer
2k
views
Open IE and Interact with Web Form using Excel VBA
I'm trying to create an excel spreadsheet with a landing page where I input a specific week number, period number and/or year.
I would then click a button to open an instance of Internet Explorer, ...
- 33
1
vote
1
answer
1k
views
Save result of javascript function from web page in Excel VBA
I am coding a macro in excel for web scraping from a particular web page. I am able to go to the web page.The problem is, in that page, there is a hyperlink, which is associated with a java script ...
- 41
0
votes
1
answer
2k
views
Scraping HTML tables using VBA
Using the below script I'm successfully returning values from the HTML tables into the workbook from the following links: link1 and link2. But when I'm trying to use the same script for the following ...
- 459
1
vote
1
answer
3k
views
VBA to loop through multiple HTML tables
Here is the link from where I'm trying to return price values only: https://www.express-supp...
I have got a VBA script which returns all product-grid-details table values into the workbook but some ...
- 459
1
vote
1
answer
649
views
how to download data using vba excel 2011
I've seen this answer: html parsing of cricinfo scorecards
these variable types, however, are not available in excel 2011:
Dim tbl As HTMLTable
Dim tr As HTMLTableRow
Is there another way to get ...
- 9,579