Populate a textarea in a webpage from excel using VBA and Fetch error message into the excel columns

Deepikadass

New Member
Joined
Jun 7, 2021
Messages
1
Office Version
  1. 2007
Platform
  1. Windows
Hi I'm new here and also new to VBA i want to automate a process i want to fetch an excel sheet 1 column A value one by one and check whether it shows an error or not by fetching the error message into column B according to the values fetched. I have been trying it to work in chrome also every time the page gets reloaded so the element id is changing so iI cant populate the text area. Any suggestions are helpful Let me clear the process in a simple way

Excel Sheet 1 Column A has values from 1 to 10

The value from A1 must be fetched and entered into the text area.

If the value shows an error, the error msg must be fetched into column B1 The div class="tp- BSjkhK KJHjhskja" is where the error shows

If no Error leaves the column empty.

after fetching the error msg into B1 the value from A2 must be fetched to the website textarea and check for error

iI want to populate and check error for the values in the column A1 to A10

here is the
CSS:
    <div class="tp- ghdtsj hadsiHS">

<label for="id-KJNHKShsishd"
data-testid="label"
class="tp- sdjbnlsdnkd">Data</label>

<div class="tp- sdjkbsjKHKJ JKnh">

<textarea placeholder="Paste your Name Data here"
data-testid="native-input"
id="id-BHSsdhgaiJHG zmnccJ"   '''{The id is changing every time on page reload}'''
class="sc-hRxedE fUNANR">
</textarea>

</div>
</div>
<div class="tp- BSjkhK KJHjhskja"></div>   '''{This where the error message shows}''
CSS of the form
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,223,888
Messages
6,175,207
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top