Excel + Team Time

Objective:

Check PAN name & linkage with Aadhaar.

Purpose

1. Enter PAN
2. Check Name & Aadhaar Link

Prompt

I want a VBA macro using Selenium to automate multiple PAN verifications on the TRACES website (https://www.tdscpc.gov.in/).

It should:

1. Launch Chrome and open the TRACES login page.
2. Enter login credentials (username in cell H2, password in H3, TAN in H4).
3. Pause for manual CAPTCHA entry, then log in.
4. Loop through a list of PANs in column A (starting from row 2).
5. Navigate to the PAN verification page.
6. Input each PAN and select '26Q' as the form type.
7. Click Verify.
8. Extract:
9. Name
10. Status
11. Additional Info
12. into columns B, C, and D respectively.
13. Use .ClickDouble if required for submission.
14. Include all necessary error handling.

Tools Required:

1. VBA Macro
2. SeleniumBasic
3. Google Chrome