+ Reply to Thread
Results 1 to 12 of 12

Inner text data from web page

  1. #1
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Inner text data from web page

    I am having trouble grabbing the inner text (4.00% and 4.25%) from a web pages source code... Any help would be greatly appriciated...

    Source Code:
    HTML Code: 
    VBA Coding:
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Inner text data from web page

    Hi,

    What output you are getting currently and if possible let us know the web site address.

    Regards
    taps

  3. #3
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Inner text data from web page

    Thanks for the response...

    I'm getting no output and the link is..
    https://www.fanniemae.com/singlefami...e-modification

  4. #4
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Inner text data from web page

    Hi Smith3rs,

    I think the code you have provide is partial code. However, try this one, here small modification has done...

    Please Login or Register  to view this content.
    regards
    taps

  5. #5
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Inner text data from web page

    Hey Taps - Here is the full code.. maybe you can tailor your code to fit in it.. thanks

    Please Login or Register  to view this content.

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Inner text data from web page

    Another way - this will be much faster:
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Inner text data from web page

    Hey Kyle -

    Wow that worked out great! Thank you very much sir.

  8. #8
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Inner text data from web page

    No problem

    Tanks for the feedback

  9. #9
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Inner text data from web page

    Hi Kyle123,

    Your code is fantastic

    Hi Smith3rs,

    Although Kyle's code is working fine, I am also attaching a code which is modified version of your code.
    It is working fine in my computer


    Please Login or Register  to view this content.
    regards
    taps

  10. #10
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Inner text data from web page

    Thanks

    Try to avoid using Internet Explorer unless you really need to, it's slow and nasty. If you are wanting to use the document object model as above, consider:
    Please Login or Register  to view this content.

  11. #11
    Forum Contributor
    Join Date
    09-29-2011
    Location
    Kolkata, India
    MS-Off Ver
    Excel 2003/2007
    Posts
    182

    Re: Inner text data from web page

    Thanks a ton

    Regards
    taps

  12. #12
    Registered User
    Join Date
    06-25-2013
    Location
    Minnesota
    MS-Off Ver
    Excel 2010
    Posts
    22

    Re: Inner text data from web page

    You guys are awesome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1