VBA code to automate hall-tickets printing process from a web page

AKSNivas

New Member
Joined
Apr 4, 2021
Messages
7
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
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
 

Attachments

  • Hall-ticket numbers.JPG
    Hall-ticket numbers.JPG
    26.5 KB · Views: 2
  • Web page to paste hall-ticket number.JPG
    Web page to paste hall-ticket number.JPG
    33.1 KB · Views: 3
  • Print-1.JPG
    Print-1.JPG
    67.4 KB · Views: 2
  • Print-2.JPG
    Print-2.JPG
    55.9 KB · Views: 2
  • Print-3.JPG
    Print-3.JPG
    25.8 KB · Views: 2

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

AKSNivas

New Member
Joined
Apr 4, 2021
Messages
7
Office Version
  1. 365
  2. 2007
Platform
  1. Windows

ADVERTISEMENT

Hi guyzz....plz help me out....
 

Marc L

Well-known Member
Joined
Apr 5, 2021
Messages
576
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

Wild cross posting ‼ :mad:
 

Watch MrExcel Video

Forum statistics

Threads
1,130,112
Messages
5,640,165
Members
417,128
Latest member
Xianter

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
Top