+ Reply to Thread
Results 1 to 1 of 1

Copy data from html into excel using vba code

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Bucuresti
    MS-Off Ver
    Excel 2007
    Posts
    12

    Copy data from html into excel using vba code

    Hello!
    I would like to ask a favor from the specialists here : I need a VBA code that can copy some tables/ charts from a website. The website is bet365.com, and the tablesare placed in the section: Results (at the bottom of the page)> Search Criteria: (Sport: Virtual Soccer, Date: Last 48 hrs, Search by : Virtual Soccer). Then you click the button “Get Results”. Then the website will display a list of the matches from the last 48 hrs. First of all, I need the code to open each match in a separate window and to copy a table from that page, and then to paste it in Excel. Secondly, if I repeat the action after 8hrs, for example, the site will show the matches from thelast 48hrs, and the code will have to check which is the last table I copied and to continue to paste from that point on, on the same sheet.In order to make things more clear, I also attached a file illustrating on Sheet2 how Ineed things to look in the end.
    Thank you in advance!
    PS: In order to be able to access the section “Results”, autentification is required, and I will provide the usename and password in private.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Parse Data from HTML Code / Website to Excel
    By rkymtns in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 10:54 PM
  2. Import/pull data from html code into excel
    By emoandy05 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 01:39 PM
  3. Saving Excel (html code) to KML
    By NTB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-26-2011, 02:58 PM
  4. HTML code in excel
    By avanishjoshi in forum Excel General
    Replies: 1
    Last Post: 06-24-2009, 05:35 AM
  5. How to copy a set of data from an Excel table and display it in html?
    By sapphire in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2008, 08:27 PM

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