htmldoc | HTML Conversion Software | Document Editor library

The "Old way" has worked for many years through VBA, it makes regular queries to the website below to collect the weather via Internet Explorer. However, now the minute IE is called, it opens in Edge and the code fails.

I have been trying to get the same code to work via XML v6 and have nearly succeeded with the "New way". I can get a single page to load but I need to incorporate the logic where an area code is input into a search box before a button is pressed on the website.

The Input box is HTMLDoc.getElementById("keyword").
The button is HTMLDoc.getElementsByTagName("button").

Only once the area is entered, and the button is pressed, does the weather for that region get returned.

Is it possible to make this query the New way?

I learnt this may be possible with Selenium and a web driver query in VBA. However, I heard that each time Microsoft Edge gets update, you need to download a new driver for the web driver, which seems like over-kill given how basic the query is.

Old way

I have an MSHTML.HTMLDocument code that:

1. Opens the page "https://www.ksestocks.com/HistoryHighLow"

2. Fills an input i.e 786

3. Then click on a button to fetch a table

4. There I catch a row and its 4 children using the following code

   ...

I was wondering if anyone could help me with this problem that has been plaguing me.

I am currently using Qt Creator with verion 5.11.3 Qt on Ubuntu to build a project. Every time I try to build I get the error "gl.h: No such file or directory".

The error occurs next to the line in my code that says "#include

I have ran the following code as well and it did not change the outcome

I am trying to automate the click on Excel icon action to download Excel data using VBA from the following link Financial Statement of a Firm

The below is a html code for that Excel icon

Hi there, hoping that someone can help me. On this example link: https://www.academiadasapostas.com/stats/competition/brasil/26

I want to get all the href links which are the target of the "VS". I'm trying examples like this one:

I have some VBA code that makes a request to https://nt3-s.zacks.com/fundamreports/Default.aspx and extracts all the data to a worksheet. My issue is that my parsing technique takes a very long time. Does anyone have any suggestions on how I can improve what the code below does? Maybe I should utilize QuerySelectorAll() or some other method...

The following code pulls pysicochemical properties from the following link into excel:

https://echa.europa.eu/brief-profile/-/briefprofile/100.002.098

I wish to pull data into excel from the following link: https://echa.europa.eu/registration-dossier/-/registered-dossier/13817/7/1 for Tox summaries for inhalation routes, dermal, eyes etc

The code below partly achieves this

I am trying to create a macro that can take data input from the user and change two parameters(using the input) in my code template. After which I want the macro to be able to copy and paste that template with the updated parameters onto an existing module.

My code accesses a website and scrapes data from it. After which I take a value in my data and put it into specific cells. Now, my code has to access different urls and put the data into a different cell each time, which are the two parameters I am trying to change.

Is there a way to create a code that makes it more user-friendly? Whereby you do not have to access the code editor to change these parameters but instead use an input box which the user can provide info and do the steps above?

Ive tried looking up on the internet about my problem but have not been able to find any methods that can take user input and change the code according to the input.

Any help would be appreciated!

Code template