Find the page size of 100's of URL's i have

Find the page size of 100's of URL's i have

I need help with a excel macro or vbs that can check all URL's i have and give me the file size in KB and MB

Website URL's like

www.somename.com
www.somename.com/title

thanks
LVL 11
bsharathAsked:
Who is Participating?
 
David L. HansenConnect With a Mentor Programmer AnalystCommented:
Since memory usage is not something that you can evaluate from Excel (even using VBA..that I've ever seen) you'll have to do some cutting and pasting.  This is what I suggest:

1.  Load up a bunch of tabs in chrome (if they are in your spreadsheet as links and chrome is your default browser, you'll just need to click ea. link).

2.  After loading as many as you can safely load, bring up the Chrome task manager (use: Shift+Esc).

3.  At this point you'll need to click on "Stats for nerds" and you'll see a new tab open with all the memory usage information you want.

4.  Select the rows, ONLY the rows.  Do not select headers or totals, just the rows.  Copy (use Ctrl+C or Right-click and "copy").

5.  Paste into Excel.  Appropriate cells should display the memory data.

NOTE: To sort by memory usage I had to remove the "k" from each memory entry (ie. 546111k to 546111).  A macro can make this step easier.
0
 
David L. HansenProgrammer AnalystCommented:
When you say page-size do you mean number of pages to print if you were to go to that website and print???
0
 
David L. HansenProgrammer AnalystCommented:
Sorry...duh.  Didn't read all of what you had.  Can you give a sample of your worksheet...does it just have urls on it?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
bsharathAuthor Commented:
Yes just URL's
0
 
David L. HansenProgrammer AnalystCommented:
I'm not sure how much this will help...but, the link below will give you all the information you are after.  It just doesn't do it from Excel.  Will this do?

http://www.raymond.cc/blog/how-much-memory-does-a-webpage-in-a-tab-take-up-in-web-browser/
0
 
bsharathAuthor Commented:
I need to query 100's of them and get it in a file so i can filter and find the largest
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.