Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-01-08
6
Medium Priority
?
283 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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 2000 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

715 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