Solved

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

Posted on 2013-01-08
6
277 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
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!

 
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

759 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