+ Reply to Thread
Results 1 to 4 of 4

Using VBA to pull data from a youtube search (HTML)

  1. #1
    Registered User
    Join Date
    04-18-2015
    Location
    Provo, Utah
    MS-Off Ver
    365
    Posts
    3

    Using VBA to pull data from a youtube search (HTML)

    Hello! I am new to VBA, and I am having a hard time figuring out how to move forward with this code that I am working on. I have excel set up to create a custom search URL based on what I am looking for, and I have that in cell(2,2). I have my code set up to use that search URL, but I can't figure out how to pull the links I need (they are all tagged with "href" in the HTML code) and put them in a column back in my excel sheet. Below is my code thus far, any suggestions?


    Please Login or Register  to view this content.
    Last edited by alansidman; 04-18-2015 at 03:33 PM. Reason: code tags

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Using VBA to pull data from a youtube search (HTML)

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    04-18-2015
    Location
    Provo, Utah
    MS-Off Ver
    365
    Posts
    3

    Re: Using VBA to pull data from a youtube search (HTML)

    Thank you for helping me with that! I'll make sure to include the code tags next time.

  4. #4
    Registered User
    Join Date
    04-18-2015
    Location
    Provo, Utah
    MS-Off Ver
    365
    Posts
    3

    Re: Using VBA to pull data from a youtube search (HTML)

    Hello again! Think that I am making a little progress, but I'm still having trouble. I need help to parse the strings from the HTML code and writing to them to cells via VBA code. I am looking to create a list of youtube channels based on my search. I can get IE to open to the page I want, but I cannot pull the channel names and place them in a list in my workbook.

    It seems that my getelementsbytagname operation keeps having issues.

    Would someone be able to give me some direction on how to create said list?

    Here is my code:

    Please Login or Register  to view this content.
    Last edited by aradicalpenguin; 04-22-2015 at 10:42 AM. Reason: Updated code

+ 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. How to search for data on one sheet and pull it over to another.
    By samdegg in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-22-2013, 03:27 PM
  2. Pull data from HTML tag which is unique (tag within a tag)
    By gochel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2013, 08:54 PM
  3. Pls HELP: Need macro to pull data off PDF/HTML files and arrange in rows
    By ruriimasu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 01:47 AM
  4. 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
  5. pull data to HTML from excel table
    By yrndtn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2010, 04:11 PM

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