PDA

View Full Version : VBA & IE Form



imgaur7
01-05-2018, 09:44 AM
Hi,

I am working on some web data fill design and need your help and time here, I tried to put the need in a very simple way (i think) for better understand and based on that MAY be I will be able to get to the goal.

Considering demo html/xml page and excel file which contains data to process

In a web page the drop down or text or checkbox are defined with their class name and option are numbers, and this is help to find and fill the data



Flow Chart Step
Data


Open IE Page from Excel URL
Excel Data


Search for Div Class
Excel Data


search for option value
Excel Data


Fill the data as per option value



Search for Div Class
Excel Data


search for option value
Excel Data


Fill the data as per option value



Search for Div Class
Excel Data


Enter the text in box
Excel Data


Search for Div Class
Excel Data


Select checkbox based on option
Excel Data


wait for 5 sec



submit form



close IE Current page



Loop the process till last value in excel



-----------------------------------------------------------------------

for example data sheet please find the data sheet.

Kindly help.

imgaur7
01-07-2018, 08:55 AM
Hi,

I am working on some web data fill design and need your help and time here, I tried to put the need in a very simple way (i think) for better understand and based on that MAY be I will be able to get to the goal.

Considering demo html/xml page and excel file which contains data to process

In a web page the drop down or text or checkbox are defined with their class name and option are numbers, and this is help to find and fill the data



Flow Chart Step
Data


Open IE Page from Excel URL
Excel Data


Search for Div Class
Excel Data


search for option value
Excel Data


Fill the data as per option value



Search for Div Class
Excel Data


search for option value
Excel Data


Fill the data as per option value



Search for Div Class
Excel Data


Enter the text in box
Excel Data


Search for Div Class
Excel Data


Select checkbox based on option
Excel Data


wait for 5 sec



submit form



close IE Current page



Loop the process till last value in excel



-----------------------------------------------------------------------

for example data sheet please find the data sheet.

Kindly help.

I'm looking forward to the respective knowledgeable people for your help...if possible....kindly check if it is possible...I'm new