count rows in a HTML table and add the value to a cell in Excel

[hahnice]

I would like to have a macro that can be initiated from an excel worksheet to lookup a specific HTML table on our intranet (Radius logins), then count the amount of rows in that table (logins) and add the row count into a cell in excel. I know how to get the actual table into excel but I have over 1200 lookups I need to do so I dont want to import over 1200 tables when all I need to know is the amount of rows.

[hahnice]

Actually the page is written in Visual basic .net 7.1. Not sure if this helps

[hahnice]

I have figured out the answer but since nobody replied I guess it wasnt of any interest. If anyone needs the answer to this problem I can supply it.

[vlady]

Nice!!

Maybe You could post it so other's could can take a look at it and also learn something new.

Thanks.

[hahnice]

I found some code on the net and modified it to suit. The original code can be found on http://www.mrexcel.com/forum/showthread.php?t=390072
My code looks up a table from a web page (Username authentications from a Radius server) then copies the table to a separate sheet (sheet2). Then counts the rows (amount of authentications in 24hrs) in the table and adds the result to the column in sheet 1. With this macro I can run through a thousand or more lookup's in less than a couple of minutes.
You may have to modify it to suit

Please Login or Register  to view this content.

[Cutter]

@ hahnice

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.