Results 1 to 1 of 1

Macro and/or Query To Extract "Views" From Youtube

Threaded View

Billy Dee Macro and/or Query To Extract... 08-27-2013, 10:28 PM
  1. #1
    Registered User
    Join Date
    10-09-2010
    Location
    Montreal, Quebec
    MS-Off Ver
    Excel 2016
    Posts
    26

    Macro and/or Query To Extract "Views" From Youtube

    An example is this link below. I am looking for view count information on all songs that happen to be on page 1, page 2, page 3.... etc.

    http://www.youtube.com/results?searc...del+rey&page=1

    In attachment enclosed you will see my results from making a simple web query. It's crude and not very useful to me in it's current state. This is pretty much where I need help as my abilities do not go any further.

    Ideally, what I need is an automated macro and/or query that will.

    A. Go to this link
    B. Extract all information
    C. Date and time stamp it.
    D. Save it.

    In this case in 5 minute intervals.

    - I do not want to override any previously saved data.
    - In this case, all I need is:

    A. The title. In this case the first title is in row 86.
    B. Who it's by (row 89)
    C. When it came out (row 90)
    D. The amount of views.

    The same formula works for additional songs. (IE: 2nd song is row 96, who is row 99, came out is row 100 and view is row 101.

    The rest of the data is useless and can be discarded. Ideally would love this to all be in the row going horizontally instead of the current vertical.

    Further, in this case it's a bit interesting, as Lana Del Rey has multiple pages of songs on Youtube. I need an option to view all pages, and of course I have no idea how to do this.

    Would also need it to go and create a new worksheet once the first one has reach 30,000 rows.

    Challenging ? Any takers ?

    Thanks !
    Attached Files Attached Files
    Last edited by Billy Dee; 08-27-2013 at 10:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2010 -- "Visual Basic" "Macros" and "Record Macro" all disabled.
    By NicholasL in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2017, 06:11 AM
  2. [SOLVED] Writing an "extra hidden sheet" Macro
    By Jongering in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2012, 08:35 AM
  3. How can i copy value from "HTMLText"(EMBED("Forms.HTML:Text","")),using Macro
    By andrewyang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-18-2010, 12:47 AM
  4. Replies: 5
    Last Post: 03-22-2006, 01:30 PM
  5. XL2000 "Custon Views" "Column width" Problem
    By Des in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 10:05 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