+ Reply to Thread
Results 1 to 4 of 4

import specific data from a webpage into excel with VBA

  1. #1
    Registered User
    Join Date
    06-11-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    7

    import specific data from a webpage into excel with VBA

    Hi Guys, I would like to know if somebody can help me how can a macros be writen, that macros will do the following action: Creat a new sheet with a specific name, in which sheet it will import a specific data from a website, which data should select it from the html tags like H2 tag and the table class="financialStatement" as a pointer which table information should get. and put it inside the sheet, so after that when I hit the macros button again it will do the same thing with a another URL and it will create a new sheet next to the alreay exist one. Thanks.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: import specific data from a webpage into excel with VBA

    Hello wolfram13,

    Welcome to the Forum!

    Do you have a workbook you can post or any other examples that we can work from?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    06-11-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: import specific data from a webpage into excel with VBA

    post is deleted by poster
    Last edited by wolfram13; 06-13-2013 at 01:26 PM.

  4. #4
    Registered User
    Join Date
    06-11-2013
    Location
    Bulgaria
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: import specific data from a webpage into excel with VBA

    In this case where I see a dificult is that I would like to importa a whole table and the formating to be the same in excel as the cells to be the same and also the styles, here is the formating method which I am using:

    Please Login or Register  to view this content.
    With this methond I am importing from the html code the first table in the page inside the string fST, which is placed inside fStatement which have the current tange =Sheet1!$B$5:$G$24

    what is happening right now is that the whole page is imported inside each cell of the excell, how to import it with the proper formating ?

    the import URL is this one view-source:http://investing.businessweek.com/re...icker=LAS/A:CN

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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