Dear experts
I have task of printing out hall-tickets of about 400 students from the below web page:
This involves a repetitive 9-step process for every single hall-ticket.
Step-1: Copy hall-ticket number from Excel file (as shown in the appended image-1)
Step-2: Switch to Web page
Step-3: Double click inside the box provided in the web page to select preoccupied hall-ticket number if any (as shown in the appended image-3)
Step-4: Paste the copied value to overwrite the preoccupied hall-ticket number
Step-5: Click on the adjacent button, "Download Hall Ticket" (as shown in the appended image-2)
Step-6: Click on the Print button (top right corner) in the resultant page (as shown in the appended image-3)
Step-7: Click on the Print button (bottom right corner) in the resultant page (as shown in the appended image-4)
Step-8: Click to go back (as shown in the appended image-5)
Step-9: Switch to Excel sheet to repeat all 9 steps again.
I will be very grateful if somebody can help me out with VBA code to automate the above recurring steps. Please let me know if any further information is needed.
Kindly do the needful.
Kind Regards
KumarSreenivas A
I have task of printing out hall-tickets of about 400 students from the below web page:
This involves a repetitive 9-step process for every single hall-ticket.
Step-1: Copy hall-ticket number from Excel file (as shown in the appended image-1)
Step-2: Switch to Web page
Step-3: Double click inside the box provided in the web page to select preoccupied hall-ticket number if any (as shown in the appended image-3)
Step-4: Paste the copied value to overwrite the preoccupied hall-ticket number
Step-5: Click on the adjacent button, "Download Hall Ticket" (as shown in the appended image-2)
Step-6: Click on the Print button (top right corner) in the resultant page (as shown in the appended image-3)
Step-7: Click on the Print button (bottom right corner) in the resultant page (as shown in the appended image-4)
Step-8: Click to go back (as shown in the appended image-5)
Step-9: Switch to Excel sheet to repeat all 9 steps again.
I will be very grateful if somebody can help me out with VBA code to automate the above recurring steps. Please let me know if any further information is needed.
Kindly do the needful.
Kind Regards
KumarSreenivas A