InternetExplorer | Messin ' around with three.js and webVR | Augmented Reality library

I am trying to automate few test cases from different test cases in sequential manner. i.e. one after another test class execution.

In some of cases, web application is not getting closed/quit. i.e. driver instance not closing/quitting. I am trying to quit/close driver in @AfterClass method as well as test class level as well but its not working in both cases.

In TestNG Suite results, its showing as its tried to executed but webdriver instances are NOT closed and new webpage instance is open.

For reference I have shared code for 1st two test classes.

Please check below snippet for code:

I am trying to get a table from a website into my excel sheet. Since the website has a log in and I need to click a few buttons to get to the table, I am using VBA.

The code I have so far is just a test, it is not the actual website that I am trying to log into. So far, the code is able to launch the website and get the inner text from the table, but it only pastes it into a single cell. How can I paste the table by keeping the same formatting?

I'm getting the error as per the image. Error_img

I tried the following code to solve it.

Method 1 :

Trying to get powershell ISE to automatically go to website and click a "No" button. I have tried to get the element by tag name but its only starting Internet Explorer but after that it just can't get the element any help would be appreciated:

I am fairly new to vba and am self taught but have gotten my vba to log in to my website and get to the homepage. Next I need to click on a submenu item but I am struggling to find it. When manually doing this, the submenu works when I hover over the icon and the click on a button called "Comed Reports" below which I believe is the element ID "Report1017".

Below is the html code from the website:

And below is where my code is at this stage:

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

I have created a macro which scrapes relevant information from Brief profiles (BP) that can be searched for at: https://echa.europa.eu/information-on-chemicals

This works using an XMLHTTP request to the URL of the Brief Profile and works fine.

I now wish to create a macro which searches the same website to find the URL(href) of the brief profile.

As a beginner to VBA I have successfully achieved this using a browser but I wish to convert this to XML HTTP request to improve efficiency.

Using IE Browser Automation:

I'm currently working as a temp in the HR department of a major hospital. In order to convince the powers that be of the need to upgrade from the "trial version" to the "salary + benefits" subscription model of my employment contract I've decided to take on a bit of a project.

The excel spreadsheet will log into a vendor website and download a report with a list of employees currently out on sick leave, then it will log into the website of our insurance company and pull information on STD claims for use by payroll (this is currently done manually by a 70 yr old lady who types at 30 WPM..... and no, she does not even use basic copy and paste).

Everything works just fine up until the point where I click the button to download the report. I'm having trouble figuring out the syntax to download the spreadsheet. Switching to chrome and using Selenium isn't an option, due to our IT departments blinding levels of bureaucracy.

Here is the code I have so far. Office 16.0 office library, HTML object library, and microsoft internet controls are included in references.

Module 1

I am slowly exploring if I can use VBA to code a macro that will search a website from a list of keywords/codes in column A and extract the data. Currently The code below searches the desired website using the range in ("A1") only but does get to the right page with the data I wish to extract. In this case the Code in a1 is 100-52-7