Download innertext from html pages

Hi

this code download innertext of instagram urls

urls  >>> sheet 1 : a1 to lastrow 

but why err  in Third url

im Amateur  pls help me.

pic 🙁http://s9.picofile.com/file/8336922700/6789.png)

 

 

Sub test()

    Dim wb As Object
    Dim doc As Object
    Dim sURL As String
    Dim lastrow As Long
    Dim n As Integer
    Dim i As Integer
    Dim HtmlToText As String
    Dim result
    lastrow = Sheet1.Cells(Rows.Count, “A”).End(xlUp).Row
    For i = 2 To lastrow
       
        Set wb = CreateObject(“internetExplorer.Application”)
        sURL = Cells(i, 1)
        wb.navigate sURL
        wb.Visible = False
        While wb.Busy
          DoEvents
        Wend
        ‘HTML document
        Set doc = wb.document
        Dim Name As Variant
        Dim Posts As Variant
        Dim Following As Variant
        Dim Followers As Variant
        Dim DivValue As Variant
        Dim DivValueSplit As Variant
        Dim DivValueResult As Variant
        Dim Biography As Variant
       
       Name = doc.getElementsByClassName(“AC5d8 notranslate”)(0).innerText
        Posts = doc.getElementsByClassName(“g47SY”)(0).innerText
        Followers = doc.getElementsByClassName(“g47SY”)(1).innerText
        Following = doc.getElementsByClassName(“g47SY”)(2).innerText
       
        ‘dd = web.document.querySelector(“div.-vDIg span”).innerText
       
       DivValue = doc.getElementsByClassName(“-vDIg”)(0).innerHTML
        DivValueSplit = Split(DivValue, “<br>”)
        DivValueResult = DivValueSplit(1)
        j = InStr(DivValueResult, “</span>”)
        Biography = Mid(DivValueResult, 7, j – 7)
      Worksheets(“sheet1”).Cells(i, 2) = Name
        Worksheets(“sheet1”).Cells(i, 3) = Followers
        Worksheets(“sheet1”).Cells(i, 4) = Following
        Worksheets(“sheet1”).Cells(i, 5) = Posts
        Worksheets(“sheet1”).Cells(i, 6) = Biography
       
        Biography = Replace(re1, “<span>”, “”)
               
        Cells(i, 2) = HtmlToText
         myarray = Split(Data, vbCrLf)
err_clear:
        If Err <> 0 Then
          Err.Clear
          Resume Next
        End If
        wb.Quit
           
    Next i

End Sub

 

By: kaprio

3,636 thoughts on “Download innertext from html pages

  1. game slot online uang asli

    Having read this I believed it was rather informative. I appreciate you spending some time and energy to put this content together. I once again find myself spending way too much time both reading and posting comments. But so what, it was still worth it!

  2. cheap wigs human hair

    cheap wigs human hair
    Jennifer Petite by Louis Ferre is a classic modern day page.
    Long wispy bangs, and a carefully thinned body make this the
    one monofilament cap wig you’ll want to wear most often. The cap is also
    hand tied which makes for a very natural fall. The lines are blurring and many solicitors now have the right
    to appear in the Crown Court on serious matters.Most solicitors are those who have
    an advisory role or draft contracts. All my work is geared
    towards presenting the best case I can in court, but the vast majority
    of my time is spent out of court interviewing clients and witnesses, working with experts, reviewing documents, doing legal research, and trying
    to settle the cases. Is your work similar, or are you really more focused on presenting a case that someone else has worked up?Traditionally,
    and for the most part still today, barristers practice completely separately from solicitors, in their own chambers, together with other
    barristers, in “sets” of chambers, which are somewhat similar to
    law firms.Barristers can now be partners in law firms,
    or be employed by them, and exercise rights of audience.

    wigs Daniel, orphaned at the age of 15, was apprenticed to a merchant who brought him to
    Amsterdam. He developed the Fahrenheit scale and reliable thermometers
    with alcohol and mercury. His studies led to a better understanding of the boiling and freezing points of
    water; he also developed a method for supercooling water.
    wigs

    U Tip Extensions For example a 12″ figure will require a 12″
    tall chart; an 18″ figure will require an 18″ tall chart, so on and
    so forth. Alternatively you could search the net
    for a proportion chart with equal results. This will keep our figure more realistic but
    not dumpy or too elongated. U Tip Extensions

    wigs So basically this is worse than the default settings because most computers can hit much higher than minimum 60FPS.

    The default settings let you drop below, this doesn FO4 came out,
    I made a video that got 500k views demonstrating the game tickrate was still tied to framerate.
    Yet it is being spread as “confirmed”.. wigs

    wigs for women The few who can speak are usually tuneless
    band geeks who spend all day fooling around in Guitar Center playing with delay
    pedals. Much like any song they craft, a conversation with a
    Post Rocker can last 15 minutes and 38 seconds with
    only about a minute of pretentious substance. Bored with conventional verse chorus verse rock
    and roll (see: emo), the Post Rocker doesn have much time
    for a social life as band practice can run a bit long, especially with each
    song clocking in at an average of 12 minute long.. wigs for women

    full lace wigs You might want to compete without buying a dress at all.

    If that’s the case, find an individual or a store that
    rents dresses. Rental fees around here usually
    range from $50 to $100. I find it very strange on here that people write stuff like that when it is not true, still each to
    their own if making comments like that makes you feel good
    go for it. I have no interest in this company but I have no hair and I must say they have made my life so
    much better and their customer service is great so as I
    say each to their own. Its just strange that if you research their company you can see that repeat customers make up 57% of their sales.

    full lace wigs

    cheap wigs human hair So far as I know, public libraries in the US have Interlibrary
    Services (ILS) which includes interlibrary loan. If your local public library does
    not have the actual research on hand, they can request the research from another library.
    This takes time but will make for a better paper.
    cheap wigs human hair

    I Tip extensions Not one of the more beloved Real Housewives installments,
    the first season of The Real Housewives of Dallas came and went without much fanfare.
    To be fair, it couldn’t always match the drama of some
    of its sister series, but RHOD’s aims were simpler: assemble a strong cast and have them fight over fake dog poop.

    Even those who enjoyed the first season, however, would admit that Season 2 wins the Housewives award for Most Improved.
    I Tip extensions

    lace front wigs I really happy to have been able to obtain both classic Omega models that each have its particular uses.
    I plan to wear the Seamaster whenever I near or in water and the Speedmaster when I really fast in a car or a spaceship or something.
    Anyways, I come a long way from rocking my daily Orient Ray and
    I try to cherish how lucky I am and to never take anything for
    granted. lace front wigs

    wigs online He gave the name Delphos to his long clinging sheath
    dresses that undulated with color. The name
    Delphos came from the bronze statue of the Charioteer at Delphi.
    Each garment was made of a single piece of the finest silk,
    its unique color acquired by repeated immersions in dyes whose
    shades were suggestive of moonlight or of
    the watery reflections of the Venetian lagoon. wigs online

    tape in extensions Like Malone and Wright, Lawrence found the cast to be “really warm and really welcoming” to both
    him and his ideas. He was especially impressed with how that camaraderie manifested itself
    with the cast and crew. “There also no hierarchy at all,” he said.
    tape in extensions

    costume wigs My husband and I are Active Duty USAF.
    We love the military and our career in the Air
    Force. It been our way of life since before we met and
    got married. If you asking why people struggle to lose weight and what
    should take a couple of months ends up taking years is
    because it is VERY hard to break habits especially a
    habit that you can get away from. We need to eat to survive so every
    single time you have a meal you are faced with the struggle of whether you
    will eat healthy or not, or whether you will overeat because it just so good, and
    having to make that choice several times a day it
    because much easier to make several bad choices in just the span of one day, and
    much harder to make multiple good choices.

    It hard dieting and forcing yourself to eat healthy for the average
    person so it hard picking something healthy over greasy burgers and fries so you constantly struggle with your eating and therefore losing weight.
    costume wigs

    wigs online By the Early Middle Ages, churches in Europe began staging dramatized versions
    of particular biblical events on specific days of the year.
    These dramatizations were included in order to vivify
    annual celebrations.[33] Symbolic objects and actions vestments, altars,
    censers, and pantomime performed by priests recalled the
    events which Christian ritual celebrates. These
    were extensive sets of visual signs that could be used to communicate with a largely illiterate audience.
    wigs online

    human hair wigs Pain wasn much at all. I took a few
    Motrin before bed the first two nights but nothing else.
    My belly button incision stung every once in awhile
    the second day but otherwise the worst pain was the scratched throat from the breathing tube.
    She also starred in the comedy film A Night at the Roxbury
    (1998).In April 2018, Anderson was seen promoting the WKRP in Cincinnati television series
    and other classic television series on the MeTV
    television network.Anderson has been married four times; her first three marriages
    were to: Bruce Hasselberg (1964 1966), Ross Bickell (1973 1981),
    and actor (and Stroker Ace (1983) co star) Burt Reynolds (1988 1993).
    On May 17, 2008, Anderson married musician Bob Flick, one of the founding members of the folk band
    The Brothers Four.[6][7] The couple had first met at a
    movie premiere in Minneapolis in 1963.[8] In 2003, while Anderson was in Seattle, she was reunited with Flick at a dinner and the romance was reignited.[citation needed]Anderson has two
    children: a daughter, Deidre Hoffman[9] (fathered by Hasselberg),[10] who was a school administrator in California;
    [11] and a son, Quinton Anderson Reynolds (born August
    31, 1988), whom she and Reynolds adopted.[12][13] She also has a sister named Andrea Sams.[9] Anderson’s autobiography, My Life in High Heels, was published in 1997.Growing up with parents of the World
    War II generation, who both smoked, Anderson witnessed the effects of chronic obstructive pulmonary disease (COPD), a lung disease often caused by smoking.
    In 1999, she became a spokesperson about COPD.[14] During a
    visit to Seattle for a COPD education campaign, Anderson became reacquainted with future husband Bob Flick human hair wigs.

  3. link sbobet

    Howdy! I could have sworn I’ve visited your blog before but after going through some of the articles I realized it’s new to me. Nonetheless, I’m certainly pleased I stumbled upon it and I’ll be book-marking it and checking back often!

  4. link alternatif sbobet 88

    This is the right website for anybody who would like to find out about this topic. You know so much its almost hard to argue with you (not that I actually would want to…HaHa). You definitely put a brand new spin on a subject that has been written about for ages. Excellent stuff, just great!

  5. agen sbobet 88

    Hello there! I could have sworn I’ve been to this web site before but after looking at a few of the articles I realized it’s new to me. Anyways, I’m certainly happy I stumbled upon it and I’ll be book-marking it and checking back often!

  6. login bola88

    I wanted to thank you for this fantastic read!! I certainly loved every bit of it. I’ve got you book marked to check out new stuff you post…

  7. voyeurhouse}

    Every weekend i used to pay a quick visit this site, because i
    wnt enjoyment, for tthe reason that this this web page conations in fact pleasant funny information too.

  8. login sbobet 88

    I’m amazed, I must say. Rarely do I encounter a blog that’s equally educative and interesting, and without a doubt, you have hit the nail on the head. The problem is something that too few men and women are speaking intelligently about. I’m very happy that I stumbled across this in my hunt for something regarding this.

  9. sbobet88 bola

    Howdy! This post could not be written any better! Reading through this post reminds me of my previous roommate! He always kept preaching about this. I will send this information to him. Fairly certain he’s going to have a great read. Many thanks for sharing!

  10. sbobet88 mobile

    Hi there, I believe your web site might be having web browser compatibility problems. Whenever I take a look at your site in Safari, it looks fine however, when opening in Internet Explorer, it’s got some overlapping issues. I just wanted to give you a quick heads up! Other than that, great blog!

  11. sbobet

    Nice post. I learn something totally new and challenging on websites I stumbleupon every day. It will always be interesting to read through articles from other authors and practice a little something from other web sites.

  12. Pauletta Mister

    I do not even know how I stopped up here, however I believed this submit was once great. I do not recognise who you are but definitely you are going to a famous blogger when you aren’t already 😉 Cheers!

  13. idnpoker apk

    You’re so interesting! I don’t believe I’ve truly read through something like that before. So nice to find somebody with genuine thoughts on this subject matter. Really.. thanks for starting this up. This site is one thing that is needed on the web, someone with some originality!

  14. Lexus888 Alternatif

    Hi there I am so delighted I found your webpage, I really found you by
    accident, while I was searching on Yahoo for something else,
    Nonetheless I am here now and would just like to say thanks for a
    fantastic post and a all round exciting blog (I also love the theme/design),
    I don’t have time to go through it all at the minute but I have saved it
    and also included your RSS feeds, so when I have
    time I will be back to read more, Please do keep up the superb work.

  15. idn play

    Hi, I do think this is a great website. I stumbledupon it 😉 I’m going to return yet again since i have book-marked it. Money and freedom is the best way to change, may you be rich and continue to guide others.

  16. daftar idnplay poker

    I really love your site.. Pleasant colors & theme. Did you develop this site yourself? Please reply back as I’m trying to create my very own website and want to find out where you got this from or exactly what the theme is named. Thank you!

  17. more info

    I needed to thank you for this very good read!! I definitely enjoyed every little bit of it.

    I have you bookmarked to check out new stuff you post…

  18. qq slot online

    I was extremely pleased to discover this web site. I wanted to thank you for your time for this particularly fantastic read!! I definitely appreciated every part of it and I have you saved to fav to see new information in your web site.

  19. Judi Pulsa

    May I just say what a relief to discover someone who really knows what they are talking about online. You certainly know how to bring a problem to light and make it important. More and more people need to check this out and understand this side of the story. I was surprised you aren’t more popular since you most certainly have the gift.

  20. Hellen

    Woah! I’m really loving the template/theme of this website.

    It’s simple, yet effective. A lot of times it’s tough to get that “perfect balance” between superb usability
    and appearance. I must say you have done a fantastic job with this.

    In addition, the blog loads super fast for me on Internet explorer.

    Superb Blog!

  21. s128.apk

    Good post. I learn something new and challenging on websites I stumbleupon everyday. It will always be interesting to read through articles from other writers and practice a little something from other sites.

  22. fancy text

    Wow that was unusual. I just wrote an extremely long comment but after I clicked submit my comment didn’t show up.
    Grrrr… well I’m not writing all that over again. Anyway, just wanted
    to say fantastic blog!

  23. s1288 sabung ayam

    I blog quite often and I seriously thank you for your information. This article has really peaked my interest. I’m going to book mark your website and keep checking for new information about once a week. I opted in for your RSS feed as well.

  24. s1288

    Good site you have here.. It’s hard to find good quality writing like yours these days. I really appreciate individuals like you! Take care!!

  25. daftar sbobet terbaru

    Yesterday, while I was at work, my cousin stole my iPad and tested to see if it can survive a
    thirty foot drop, just so she can be a youtube sensation. My apple ipad is now destroyed and she has 83 views.

    I know this is completely off topic but I had to share it with someone!

  26. s128

    I blog frequently and I truly appreciate your information. This great article has really peaked my interest. I am going to book mark your blog and keep checking for new information about once per week. I opted in for your Feed as well.

  27. s128

    I’m very pleased to uncover this website. I wanted to thank you for your time just for this fantastic read!! I definitely liked every part of it and I have you saved to fav to look at new things in your blog.

  28. Coin news

    Aw, this was a really good post. Taking a few minutes and actual
    effort to produce a superb article… but
    what can I say… I hesitate a whole lot and don’t seem
    to get nearly anything done.

  29. download apk s128

    This is the right site for everyone who hopes to understand this topic. You know so much its almost hard to argue with you (not that I really would want to…HaHa). You definitely put a new spin on a topic which has been written about for years. Excellent stuff, just wonderful!

  30. link alternatif s128

    After looking at a few of the blog articles on your website, I really appreciate your technique of blogging. I added it to my bookmark webpage list and will be checking back soon. Please check out my website as well and tell me how you feel.

  31. aplikasi s128

    I was pretty pleased to uncover this page. I need to to thank you for ones time due to this fantastic read!! I definitely savored every bit of it and I have you book marked to look at new things on your website.

  32. flyer design

    Pamphlets Literature or poster are amazing approach to draw in to
    customers to a firm. A great style may bring in the engagement of
    the target audience , communicate your restorative massage
    And improve your business objectives And Aims. Seeking to
    make a poster,flyer or nearly anything print out associated?

    this is the right location to obtain.

Comments are closed.