Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

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
0
bsharath
Asked:
bsharath
  • 4
  • 2
1 Solution
 
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
 
bsharathAuthor Commented:
Yes just URL's
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
David L. HansenProgrammer 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now