Solved

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

Posted on 2013-01-08
6
265 Views
Last Modified: 2013-01-13
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
0
Comment
Question by:bsharath
  • 4
  • 2
6 Comments
 
LVL 15

Expert Comment

by:David L. Hansen
ID: 38755657
When you say page-size do you mean number of pages to print if you were to go to that website and print???
0
 
LVL 15

Expert Comment

by:David L. Hansen
ID: 38755663
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
 
LVL 11

Author Comment

by:bsharath
ID: 38755697
Yes just URL's
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 15

Expert Comment

by:David L. Hansen
ID: 38755978
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
 
LVL 11

Author Comment

by:bsharath
ID: 38757587
I need to query 100's of them and get it in a file so i can filter and find the largest
0
 
LVL 15

Accepted Solution

by:
David L. Hansen earned 500 total points
ID: 38768624
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question