Explorer Compatability Mode

[JerryH09]

Hi There,
I'm doing a project where I regularly have to access www.debtbombshell.com. I would like to cut and paste on to an Excel spreadsheet but the website won't let me highlight. Help!!
regards
JerryH09

 

[mole999]

what browser are you using

it is providing a forecast of 1.1 trillion by 2011, 8 years ago

the debt would be magnitudes less if we hadn't adopted the american trillion and billion

 

[JerryH09]

Hi Mole999 Thanks for replying. I'm using Chrome 71

 

[mole999]

I can select the screen text in Firefox, not sure what part you want to lift

 

[JerryH09]

Thanks Mole999. Even in Firefox I can't highlight. The bit I'm after is the big number on the bomb.
Regards,
JerryH09

 

[mole999]

The number is individual elements from a table, each character not a single item
looks like
< div="content" >
< div id="dg0" > < img id = "d0" name = "d0" src=http://www.debtbombshell.com/digits/1.gif" alt="uk debt counter" border="0" < /div > < /div >


for every number and spacer

 

[JerryH09]

The number is individual elements from a table, each character not a single item
looks like
< div="content" >
< div id="dg0" > < img id = "d0" name = "d0" src=http://www.debtbombshell.com/digits/1.gif" alt="uk debt counter" border="0" < /div > < /div >


for every number and spacer

Hi Mole999 Firstly thanks so much for trying to help me.Secondly I completely agree that the mighty British trillion (10^18) is much better than the weedy American one (10^12). Still the numbers are a bit scary!I have used Excel for quite a few years and written a number of VBA procedures but the closest I've come to getting data from a website is Selection.Hyperlinks.Follow and I am certainly no Developer. I tried copying your code to a VBA procedure but then hit a wall. Sorry about my complete lack of knowledge but help...
Regards,
JerryH09

 

[mole999]

the code is basically the html from the site, so you can't run it (you can get browser extensions to look at the code). I estimate that the numbers change around 2,154 (to quick to identify reliably without filming) but they are not going to be factual. In chrome, right click and view page source

<tbody>

[TR]
[TD="class: line-content"]    <div id="content">
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg0"><im g name="d0" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" alt="UK debt counter" id="d0" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="sep1"><im g name="ds4" src="[URL="http://www.debtbombshell.com/digits/spacer.gif"]digits/spacer.gif[/URL]" border="0" id="ds4" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg1"><im g name="d1" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d1" alt="£931,000,000,000" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg2"><im g name="d2" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d2" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg3"><im g name="d3" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d3" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="sep2"><im g name="ds3" src="[URL="http://www.debtbombshell.com/digits/spacer.gif"]digits/spacer.gif[/URL]" border="0" id="ds3" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg4"><im g name="d4" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d4" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg5"><im g name="d5" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d5" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg6"><im g name="d6" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d6" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="sep3"><im g name="ds2" src="[URL="http://www.debtbombshell.com/digits/spacer.gif"]digits/spacer.gif[/URL]" border="0" id="ds2" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg7"><im g name="d7" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d7" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg8"><im g name="d8" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d8" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg9"><im g name="d9" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d9" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="sep4"><im g name="ds1" src="[URL="http://www.debtbombshell.com/digits/spacer.gif"]digits/spacer.gif[/URL]" border="0" id="ds1" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg10"><im g name="d10" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d10" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg11"><im g name="d11" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d11" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <div id="dg12"><im g name="d12" src="[URL="http://www.debtbombshell.com/digits/8.gif"]digits/8.gif[/URL]" border="0" id="d12" alt="" /></div>
[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <a class="large" href="[URL="http://www.debtbombshell.com/uk-national-debt.htm"]uk-national-debt.htm[/URL]"></a>[/TD]
[/TR]
[TR]
[TD="class: line-number"][/TD]
[TD="class: line-content"]      <a class="small" href="[URL="http://www.debtbombshell.com/uk-national-debt.htm"]uk-national-debt.htm[/URL]"></a>

[/TD]
[/TR]
</tbody>

 

[mole999]

For some you can

Tab Data > From Web and then follow the on screen prompts

The site has been running since 2010

We owe £14,968 for every man, woman and child
That's more than £32,361 for every person in employment
Every household will pay £1,893 this year, just to cover the interest
Copyright © 2009-2010, DebtBombshell.com

<colgroup><col><col span="4"></colgroup><tbody>
</tbody>

 

[JerryH09]

Hi Mole999,
Once again thanks for tryng to help me. Have you got anythng I can copy into a VBA procedure to give me the big number in the bomb? I would be in your debt forever. I won't bother you again.
Regards,
JerryH