Deepikadass
New Member
- Joined
- Jun 7, 2021
- Messages
- 1
- Office Version
- 2007
- Platform
- 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 of the form
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}''