Microsoft Excel - VBA HTML Table Elements - Asked By Rajender Prasad on 05-Jul-13 01:01 PM

Dear All,

 I have the below table data in one application, and the below is dynamic, how can i read these values using vba.
I get an effective date from user if effective date is falling between the second time line of the belwo, then I have click on the link to go inside of that.. but i shouls come back and click the first one also becos its greater than requested.
how can I count the number rows in a particular table dynamic//


PLAN SUMMARY [create plan] [CMS Transactions] [Enter LEP Attestation]
Plan Copay Effective Date Termination Date Status Status Reason Conservation Reason Contract PBP Passport Image # Functions
AP 0 01/01/2026   ACTIVE     H5253 030 Y IEDH11211202572618 [update][profile][change][terminate][view]
AV 4 05/01/2026 07/31/2008 TERMINATED     H2949 012 N   [update][profile][terminate]
AV 4 07/01/2026 07/01/2026 TERMINATED NEVER ACTIVE INELIGIBLE SERVICE AREA REDUCTION H2949 012 N   [update][profile][terminate]
AV 4 03/01/2026 04/30/2008 TERMINATED     H2949 012 N   [update][profile][terminate]
Harry Boughen replied to Rajender Prasad on 06-Jul-13 05:17 AM
Hello Prasad,
Is this a question about Excel?
Regards
Harry