VBA code to automate hall-tickets printing from web page

[AKSnivas]

Hi Chandoo & Team

I have a task of printing out hall-tickets of about 400 students from the below web page:
https://bie.ap.gov.in/GetPractHallTicketttt.do
This involves a recurring 9-step process for every single hall-ticket.
Step-1: Copy hall-ticket number from Excel file (as shown in Test-1.xlsm)
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-1)
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-1)
Step-6: Click on the Print button (top right corner) in the resultant page (as shown in the appended image-2)
Step-7: Click on the Print button (bottom right corner) in the resultant page (as shown in the appended image-3)
Step-8: Click to go back (as shown in the appended image-4)
Step-9: Switch to Excel sheet to copy next hall-ticket number and repeat all 9 steps again.

I will be very grateful if this forum 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

 

[AKSnivas]

Anyone.....plz help me out!

 

[Marc L]

Hi,​

​

as I can't reach your link - a never ending story and after a while an error raises ! - so I can't help, the same for many others …​

​

 

[Marc L]

And I can't help when meeting some wild cross posting ‼​

​

A must read :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[AKSnivas]

Hi,​

​

as I can't reach your link - a never ending story and after a while an error raises ! - so I can't help, the same for many others …​

​

Thank you Marc L for looking into my post. Interesting.....! When I click on the same link, I am able to see the web portal. This time I have tried "Insert link" option above & inserted the link here. Please give a try. If this too doesn't then please let me know what could be done.
https://bie.ap.gov.in/GetPractHallTicketttt.do

 

[AKSnivas]

And I can't help when meeting some wild cross posting ‼​

​

A must read :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Thank you Marc L for sharing site rules. I have read the rules now & understand.
Regarding cross posting.....it wasn't intentional at all. I do admit that I have posted the same query in another forum but didn't get any response for several days. Only then, my search continued for a better forum & came across chandoo.org
I should have deleted my post there before posting the same here. Anyways, as it is not a good practice according to your site rules, my apologies.

 

[Marc L]

It's the same with your last link : error raising like cross posting !​

​

Maybe some country restriction, you must see with someone local.​

​

 

[AKSnivas]

It's the same with your last link : error raising like cross posting !​

​

Maybe some country restriction, you must see with someone local.​

​

Ok, thank you. Now, I have to look for another forum. This is how I end-up cross posting again.